Forum Discussion
100 Stacked Column chart %age not working - Analysis Service
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!
Hi,
everything worked out, it was just a small glitch. I reset all the formats in this visual and everything was fine. 🙂
4 Replies
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
Super User
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 thishttps://powerbi.microsoft.com/en-us/blog/deep-dive-into-the-new-dynamic-format-strings-for-measures/
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
Hi,
everything worked out, it was just a small glitch. I reset all the formats in this visual and everything was fine. 🙂
