3 Replies Latest reply on Aug 27, 2015 3:29 PM by Steve Martin

How to get percentage of measure values in stacked bar graph.

Hi there. I have 4 calculated values which i can see it's value in the text. Now i'd like to get the % of the total.

Ie: last month, the blue bar should show 38.6%.

I can calculate the percentage of each value, but the bars would have a 100% height all the time, and i want to keep the individual month's height.

Doable?

• 1. Re: How to get percentage of measure values in stacked bar graph.

Hi Gabriel,

Is the attached more along the lines?

In order to stop the 100% stacked, I am still using the Sum(Sales) and then applying a percent of total to the label.

Steve

• 2. Re: How to get percentage of measure values in stacked bar graph.

Hi Steve,

Thanks for your time. The thing is, i build the stacked by using 4 measured values. Your technique works with a standard, single measure.

• 3. Re: How to get percentage of measure values in stacked bar graph.

Yes I had noticed that, not knowing what the measures are and how they work with your charts make this quite difficult to solve.

Please can you mock something up and post a packaged workbook so I can better see how your chart works.

Steve