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 all
I have an issue with a format measure against a SSAS multidimensinal cube.
If I open an excel and drag the measure in a pivot table I can see the measure with the write format but when I connect to SSSA inside Power BI (with a live connection) and I try to use this measure in a report It shows me the measure without percentage format.
And now the best thing comes,if I develop the same report in my local machine with a backup of the same cube that I have in the remote envirorment the format appears fine.
There is no change between my local envirorment and the remote one. Same version of Power BI (the lastest version) and as I said before a backup of the cube in producction.
I have other mesures with percentage format but all of them shows the write format when it uses in a report.
The measure is as easy as [measure].[Measure A] / [measure].[Measure B].
I have tested with format_string = "#,##0.0 %;-#,##0.0 %" and format_string = "percent" with the same results
Could someone give me a hand please?
Thanks in advance.
Regards.
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.