100 Stacked Column chart %age not working - Analysis Service

[Reindeer]

Hi,

I need to create 100 Stacked Column chart using a measure (Estimated Revenue). However, I am getting weird values in %age format, instead of actual 100% stacked column chart. If I hover the chart for tooltip, the values and percentage inside are correct, but I don't know what is happening in the Y axis or in chart.

Just so you know, it is a measure from Analysis service, so I said 

Estimated Revenue = Sum(Fact[Project_Estimated_Revenue])

So, the format in Estimated revenue is in Currency format. I am not sure, if this affects in any way, but I should be getting a simple graph with percentage values. From 0 to 100 and not 0.00000 M % to 0.000010 M %

Could someone tell me what might be happening here? I am not sure what is the problem here. Thank you!

[Reindeer · Accepted solution]

Hi, 

everything worked out, it was just a small glitch. I reset all the formats in this visual and everything was fine. 🙂 

[Reindeer]

Hi,

Just an update on this. I think this is some bug or something, i am always getting 0.00010M% (Max) in Y-axis, no matter which measure I choose. Could someone confirm this? 

I am using May 2023 version

[amitchandak]

@Reindeer , Go to measure tools, I doubt you have used format or dynamic formatting.

Clear format and choose percent or decimal or check have you used this

https://powerbi.microsoft.com/en-us/blog/deep-dive-into-the-new-dynamic-format-strings-for-measures/

[Reindeer]

Hi @amitchandak, 

Thanks for your reply. Yes, this is new for me, however, I am connected to Analysis Service and it doesn't allow me to use this tool. I went through your link and I don't have that option to activate dynamic formatting. (See Image Below)

Also, I removed all the formats from the Analysis Service in this measure, but no change in the output. For different testing I tried using different graphs and I see perfect results, but as soon as I select "Show value as - Percent of Grand Total", everything messes up

Graph: Clustered Column Chart

Please note: tooltip shows correct values

I just want to see the same result in Y axis and Data Values. Sorry for any confusion