Forum Discussion
Solved
Clustered Column Chart - Showing Percentages Based on Legend
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 lege...
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
v-yulgu-msft
Microsoft Employee
Microsoft EmployeeHi 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