Forum Discussion
Anonymous
5 years agoNot applicable
Create Clustered Colum with each cluster total 100%
Currently have a 100% stacked column chart:
Built in functionality gives % of total sales.
Users would like to see this as a Clustered Column Chart with each age group totaling 100%. Example: For the 18-34 age group, the total of the 5 Plan Name Net units will equal 100%
Anonymous , Try a measure like
divide([net units], calculate([net units], allexcept(Table, Table[Age groups])))
1 Reply
- amitchandak
Super User
Anonymous , Try a measure like
divide([net units], calculate([net units], allexcept(Table, Table[Age groups])))