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
Anonymous's avatar
Anonymous
Not applicable
9 years ago

I tested it on SQL Server 2016 SP1 + CU3 and Power BI Desktop June 2017 (x64). And I don't know why it's not working for you.

Hikmer's avatar
Hikmer
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Did you figure this out? We are experiencing the same issue. 

  • 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.