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?
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.