Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Team -- We have a measure in SSAS OLAP and it is formated as "0%;(0%)". It shows correctly in Excel pivot tables and even cube values. However, in PowerBI Live connection, it shows as decimal number.
FYI... I tried changing the format to "Percent" still no use.
Thanks
Krish
I tried using "Percent" as well and no luck when applying format like this:
FORMAT_STRING([Measures].[Gross Margin]) ="Percent";
However, it did work when I added it to a created memeber like this:
CREATE MEMBER CURRENTCUBE.[Measures].[Gross Margin Percent] AS
DIVIDE([Measures].[Gross Margin],[Measures].[Net Sales]),
VISIBLE = 1,
ASSOCIATED_MEASURE_GROUP = 'Measures'
, FORMAT_STRING="Percent";
I would also like to note that I was in a shared workgroup and had to delete and re-add the data connection as for it to work as the cube meta data doesn't seem to update when you hit the refresh button. Anyone know how to make the meta data refresh without having to re-add the connection?
@Anonymous I checked via my live connection and it is still working. I have attached screenshot.
Thank you very much, it helps me a lot. I will follow the different steps you described and see if I can get my % working! It seems to be tricky for a lot of people. Thank you!
Quick update.
After several attempts, using MDX orthe VS Interface, I can't make that formatting work again. Every single report that was previously showing correctly % are now showing up with no formatting.
I would be glad to be in touch with a PowerBI MS guy.
If any one has an idea please feel free to share it. It seems that more and more people are reporting that issue.
We are using Power BI Report Server - March 2018.
We have SSAS 2016 multi-dimensional cubes for analysis and reporting.
We have a calculated % measure in a multi-dimensional cube with FORMAT set to "Percent".
In Power BI (Desktop) with a LIVE connection to this multi-dimensional cube:
This inconsistency between visualizxations for the same measure (e.g. Table vs. Chart) is obviously not by design.
It is clear that Power BI is obtaining the correct formatting for this measure from the cube (as it is displaying it in the table/matrix visualisations), however it is not being consistently applied across the visualisations.
This is a show-stopper for rolling out Power BI to our target audience (i.e. Executives, Senior Management, etc.)
Same experience to me. I had the visual working with the correct formatting, and after upgrading to CU8 the visual showed decimals afterwards. I wonder, as when I insert a normal table the value is shown correct in the % form. In the queries (I ran a profiler for performance analysis) the query delivers the right format (P2). What‘s wrong there?
Hi @Krish,
I test the scenario as yours and I can reproduce the same issue as shown in the following screenshots, number format lost after I connect to SSAS using “Connect live” option in Power BI Desktop. I will report the issue internally and post back once I get any update.
Thanks,
Lydia Zhang
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
69 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |