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

Hi jockefe,

 

I've just reproduced this case by adding your measure to one of my cubes and it works perfectly fine in both Power BI Desktop and Power BI service (web browser). Can you please specify which version of SQL Server you are using, how you build the report (desktop app vs web browser), and which version of Power BI Desktop you use (if any)? 

 

Best Regards,
Pawel

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

I use SQL Server 2016 CU3

Latest version of Power BI

I build the repoort in PBI Desktop

  • 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