Forum Discussion
Formatting SSAS values (Live connection/explore live)
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.
Hello stevel, would you mind to change the status of the topic?
jmford and I are having the same issue: SSAS MD formatting was perfectly working until the December 2016 update and since then it's no longer working.
I opened a MS ticket and Power BI Engineers basically said they're aware of the issue but have no ETA to provide us with, and no workaround for now.
This is really annoying, because we've been formatting fields for over a year in all our reports and suddenly it's broken with no alternative.
Displaying 3.00 instead of 300% is really confusing for the end-user, it's really basic but still a fundamental piece when it comes to user adoption.
In my case I was able to resolve this by backing out a load of changes to calculated members in my SSAS MD cube. I am unclear specifically what the error (or char) was in the formatting that allowed the cube to deploy and calculate but corrupted the formatting in PowerBI. However when I reverted the changes - the problem was resolved. It was not a PowerBI service issue.
