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 lege...
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

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]))