Forum Discussion
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...
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.
I'm having this issue as well.
Formatted measures as \€ #,##0.00;\€ -#,##0.00 in the SSAS MD cube.
In Excel, everything is fine. In PBI Desktop, the € is missing.
Has there been any updates on this? I good portion of the data I work with is using cubes in SSAS and the formatting is a big issue.