Clustered Column Chart - Showing Percentages Based on Legend

[Chirag_Sidana]

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

[v-yulgu-msft · Accepted 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

[Chirag_Sidana]

Thank you! This is really helpful.

Regards,

Chirag

[Seward12533]

Something this this.

Pct of Total = DIVIDE([Measure]),CALCULATE([Measure],ALL(table[Category]))