Koen Verbeeck on 14 Apr 2016 17:42:51
Power BI (Desktop) supports formatting designed in the SSAS cube. However, when I format a measure as \€ #,##0.00;\€ -#,##0.00, the € sign is lost in Power BI. It works in Excel though.
- Comments (37)
RE: Better support for SSAS MD formatting
Koen, thanks for the comment about scope. I had the same problem but when I moved my scope statements up right after the CALCULATE keyword and before the first calculated member all my formats where correct again.
This trick might not work if you need to reference a calculated member in your SCOPE statement.
So I hope MS will support SSAS formats better really soon.
RE: Better support for SSAS MD formatting
The weird thing is, some formats do come through, but others don't. Depends if they are calculated measures, if there are scoped assignments and so on.
RE: Better support for SSAS MD formatting
We have a big issue with SSAS MD measures and calculated measures that are not formated when retrieved with a live Connection. Some decimal numbers can show up to ten decimals and this rally looks bad in Power BI Desktop reports.
RE: Better support for SSAS MD formatting
This is a must have! This has to be fixed, otherwise a lot of the work that is put into creating SSAS MD and Tabular is somewhat lost.
RE: Better support for SSAS MD formatting
This has to be given high priority. As all our users use %'s everywhere and it is annoying to see % as decimal.
RE: Better support for SSAS MD formatting
We would like to %'s flow through from the cube. in SSAS 86% shows up as .86 in PBI Desktop and Service.
RE: Better support for SSAS MD formatting
A related need is when you have a Currency dimension and each cell in a query can be a different format string if you put that currency dimension on rows. PBI Desktop actually already retrieves the format string for each cell but doesn't use it for formatting currently. Please complete this work.