Forum Discussion
Clustered Column Chart: Axis values totaling 100%
When creating a clustered column chart, all values included total 100%. How can each cluster in the graph total 100%? Yes, using the 100% Stacked Column Chart will give this information, but the users of the report want to visualize each cluster broken out by legend group to total 100%.
Example:
Sell three products to three age grroups.
Show the percentage of each product within each age group to total 100%
Anonymous ,not very clear. Assume you have a measure for that you want this %. You have to try like
divide([measure], calculate([measure], allexcept(Table, Table[age group])))
1 Reply
- amitchandak
Super User
Anonymous ,not very clear. Assume you have a measure for that you want this %. You have to try like
divide([measure], calculate([measure], allexcept(Table, Table[age group])))