Forum Discussion

jockefe's avatar
jockefe
Icon for Advocate IV rankAdvocate IV
9 years ago

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...
Need Help
jockefe's avatar
jockefe
Icon for Advocate IV rankAdvocate IV
8 years ago
Unfortunately not
I raised a ticket to MS and they said that this is expected/by design
Hikmer's avatar
Hikmer
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

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.  

  • LKoewing's avatar
    LKoewing
    Frequent Visitor
    6 years ago

    Change the formatting of your calculated measure coming from your Multi Dimensional cube from "Percent" to "#.##%" for example, and test.

    Worked for us.