Forum Discussion

Frequent Visitor

3 years ago

Solved

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

Reindeer
3 years ago
Hi,

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

Frequent Visitor

3 years ago

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
3 years ago
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
  Frequent Visitor
  3 years ago
  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