Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello,
I have measure in SSAS cube which is formated as percentage. I am using that measure in both clustered chart visual and in matrix visual. The problem is that the formatting is different in both the visuals. In matrix the values are getting multiplied by 100. it is also same in table visual and multi card visual. see the screen shot below.
As you can see, in chart it showing as 96.60 but in matrix it is showing as 9,660.18%. Why am I seeing two different formating in both the visual?
Hi @bhavesh-jadav,
What's the version of your Power BI Desktop? Try to use the newest version first please.
Thanks,
Xi Jin.
I am using latest version i.e. April 2018 version only. Another thing that I found is that when I do show data on both bar chart and matrix I can see values in thousands only ( see below screen shot). But the chart is dividing value with 100 but in matrix it is showing exact same value.
Why both visaul is showing same data in different way? In other charts i.e. Pi chart, combined chart etc. value is getting divided by 100 but in matrix, table and card visual, value is formatted in thousands. I am using SSAS Live connection so there is no way of changing formating in Power BI desktop.
Kindly check in the chart visual ,that it is not displaying the sum.Enable the dont summarise option in the tools pane
@Hardik I am using SSAS Live connection hence such options are not available. I am still not able to find cause of this problem.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |