This project has moved and is read-only. For the latest updates, please go here.


Check formatting for Percentage


A column of Decimal Number type in PowerPivot and Format=Percentage is displayed as Currency when I evaluate the table in DAX Studio. It should be displayed as a Percentage in Excel, too

file attachments

Closed Dec 19, 2016 at 9:40 PM by dgosbell
should be fixed in v2.6 - as long as your output column name matches then name of a measure the formatting for that measure will be applied.


mssqlgirl wrote Oct 23, 2012 at 1:41 AM

Similar issue seesm to occur for Tabular Model. A calculated measure from AdventureWorks, "Internet Total Sales" has currency formatting. It seems that the output is displayed as plain numbers on both Excel table and DAX Output grid.

    'Internet Sales'
    , "Internet Total Sales"
    , 'Internet Sales'[Internet Total Sales]

wrote Feb 14, 2013 at 9:24 PM

wrote Dec 19, 2016 at 9:40 PM