Forum Discussion
Creating a visual with measures
Hi pter14 ,
1.Create a Single Measure for Category Share
Instead of creating individual measures for each category, you can use a single dynamic measure:
Category Share = DIVIDE( SUM('Table'[Quantity]), CALCULATE(SUM('Table'[Quantity]), ALL('Table'[Category])) )
This formula calculates the share of each category’s quantity out of the total quantity dynamically.2.Use a Stacked Column Chart
- Add Category to the Axis of the visual.
- Add the Category Share measure to the Values.
- Format the visual to display percentage values.
3. Add Tooltips (Optional)
To enhance the visual:
Include additional details in the tooltip, like the total quantity or the raw value for each category, using separate measures.
Please mark this as solution if it helps yopu. Appreciate Kudos.
Hi pter14 ,
1.Create a Single Measure for Category Share
Instead of creating individual measures for each category, you can use a single dynamic measure:
Category Share = DIVIDE( SUM('Table'[Quantity]), CALCULATE(SUM('Table'[Quantity]), ALL('Table'[Category])) )
2.Use a Stacked Column Chart
- Add Category to the Axis of the visual.
- Add the Category Share measure to the Values.
- Format the visual to display percentage values.
3. Add Tooltips (Optional)
To enhance the visual:
Include additional details in the tooltip, like the total quantity or the raw value for each category, using separate measures.
Please mark this as solution if it helps yopu. Appreciate Kudos.
Dear FarhanJeelani,
Maybe a filter was on, or I dont know, but it looks like it is working now. Thank you for your assist. Could you please clarify what went wrong on my thinking?