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 and in excel - displays 50%

But independent of what visual I use in Power BI it gives me 0.5

 

I use SSAS live connection and have no possiblity to chnage the format in Power BI.

Need Help

7 Replies

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