Forum Discussion

stevel's avatar
stevel
New Member
10 years ago
Solved

Formatting SSAS values (Live connection/explore live)

I'm running into an issue where I'm not seeing anything that will allow me to format any values I'm pulling from a live connection to a SSAS multidimensional cube.     I would like to format t...
Need Help
Tips and Tricks
Tutorial Requests
  • greggyb's avatar
    greggyb
    10 years ago

    SSAS is a semantic layer in BI. This means it stores metadata natively with data. Part of this metadata is display formatting. Power View (the report component in Power BI) is designed, for better or worse, to defer to the display format metadata of its source. You should alter these display formats in your SSAS model.

Braggilicious's avatar
Braggilicious
Frequent Visitor
9 years ago

Since the fix in February, unless the aggregation function in the cube is SUM/AVG/COUNT then no formatting is applied to the measure. The ByAccount, FirstNonEmpty, LastNonEmpty, FirstChild, LastChild, AverageOfChildren aggregations do not display the correct format.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    jmford: this is weird because I have never changed the formatting of my calculations ("$#,##0;($#,##0)"). I entered it directly via the interface in VS early in 2016, and then it stopped working since December.

     

    Braggilicious: my calculation is based on a SUM, but formatting is not working though.