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

Closed

Check formatting for Percentage

description

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.

comments

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.

EVALUATE
SUMMARIZE(
    '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