Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have built a clustered column chart for the data below:
The state acts as a filter for the chart. X-Axis is category and y-axis is Value. The legend is Category. Please see image below:
I want to show % Value in this chart (instead of value).
% Value = (Sum of Value in category for the given data source)/(Sum of values across categories for the given data source)
Basically I want to show percentages in a clustered column chart based on the values in legend. I don't want to hard code the percentage values since I want to use this feature irrespective of the state filter at the top.
Can someone advice how to perform this?
Thanks in advance,
Chirag
Solved! Go to Solution.
Hi @Chirag_Sidana,
Please new a measure:
percentage = SUM ( TB[Value] ) / CALCULATE ( SUM ( TB[Value] ), ALLEXCEPT ( TB, TB[State], TB[Data Source] ) )
Best regards,
Yuliana Gu
Hi @Chirag_Sidana,
Please new a measure:
percentage = SUM ( TB[Value] ) / CALCULATE ( SUM ( TB[Value] ), ALLEXCEPT ( TB, TB[State], TB[Data Source] ) )
Best regards,
Yuliana Gu
Thank you! This is really helpful.
Regards,
Chirag
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |