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
https://blog.crossjoin.co.uk/2017/04/18/power-bi-ssas-multidimensional-and-dynamic-format-strings/
RE: Better support for SSAS MD formatting
Supporting SSAS MD Formatting is a must have.
Without the feature will clearly impacts the user adoption of PowerBI + SSAS.
Also, it will be nice to have the ability change the formatting directly in Power BI.
RE: Better support for SSAS MD formatting
Formatting measures on a SSAS MDX cube with a live connection is really unpredictable.
It seems the format of calculated measures work but formatting natural measures does not.
Please fix this issue.
RE: Better support for SSAS MD formatting
Have you tried formatting the measure as a calculations and then referencing that in Power BI? Not ideal but for whatever reason we seem to have had better luck with formatting when applying it as a calculation
RE: Better support for SSAS MD formatting
Please fix! Excited about Power BI on-premise, but this simple issue will give end-users fits!! Let's make this work like it fundamentally should, please!
RE: Better support for SSAS MD formatting
Being able to port formatting from the cube is a basic functionalities that should been there from day one. Keep in mind that Dashboard are created to be shared with Senior staff for assessments and running their groups. Specially if you are working with the finance group who is very particular on how the data should be formatted. Not having this functionality is causing extra work to compensate for this BUG, and please do not called by design. It feels like Microsoft is not listening to the user base when I hear this reply!!
RE: Better support for SSAS MD formatting
Need to have formatting for SSAS Multidimensional. Power BI doesn't support formatting from the cube. Also, it should support the ability to change the formatting directly in Power BI. Please work on this.
RE: Better support for SSAS MD formatting
This is a must have. How can we explain to our end-users 0.2 means 20%, 2 means 200% etc. It clearly impacts the user adoption.
RE: Better support for SSAS MD formatting
Through some research I found out that you can make a created member work for percent but there isn't much leeway you are stuck with 00.00%. Here is an example of what works:
CREATE MEMBER CURRENTCUBE.[Measures].[Gross Margin Percent] AS
DIVIDE([Measures].[Gross Margin],[Measures].[Net Sales]),
VISIBLE = 1,
ASSOCIATED_MEASURE_GROUP = 'Measures'
, FORMAT_STRING="Percent";
RE: Better support for SSAS MD formatting
I'm curious how this issue isn't affecting more people (based on the number of votes)? Is it that not many customers are using SSAS MD with this tool or are they not using live connections? Or is there some trick a few of us are missing to make the passthrough formatting work?