Forum Discussion

Chirag_Sidana's avatar
Chirag_Sidana
Frequent Visitor
8 years ago
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 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

Show and Tell
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    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

3 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    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

  • Seward12533's avatar
    Seward12533
    Icon for Solution Sage rankSolution Sage
    8 years ago
    Something this this.

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