Forum Discussion
format string percent does not work in power bi
I have a SSAS Olap cube with a calculated measure CREATE MEMBER CURRENTCUBE.[Measures].[percent test] AS 1/2 ,VISIBLE = 1 ,FORMAT_STRING = 'Percent'; This works fine in management studio a...
What I am encountering, is that is WAS working...now it is not formating correctly. As of last week, visualizations no longer show percentages (we are using the "0.00%" and "0.0%" format strings). In Excel and PowerBI tables, the percent formating is correct. Only when using a PowerBI chart or visualizations is it not honoring the format string. It is way frustrating trying to figure out the problem.
Change the formatting of your calculated measure coming from your Multi Dimensional cube from "Percent" to "#.##%" for example, and test.
Worked for us.