Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |