I have a SSAS Olap cube with a calculated measure
CREATE MEMBER CURRENTCUBE.[Measures].[percent test] AS
,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.
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)?
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.
Click here to learn more about the August 2022 updates!
Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.