Forum Discussion

mdex's avatar
mdex
Icon for Resolver I rankResolver I
6 years ago
Solved

Calculating Column/X Axis Percentage in Stacked Bar Chart

Hi,   I have a matrix table show below that has the ability to show the percentage of column total.            I'd like to also present the same data as a stacked bar chart but the item...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    HI mdex,

    You can try to use the following measure formula if they suitable for your requirement:

    Measure =
DIVIDE (
    CALCULATE (
        SUM ( Table[Amount] ),
        ALLSELECTED ( Table ),
        VALUES ( Table[Role] ),
        VALUES ( Table[Date] )
    ),
    CALCULATE ( SUM ( Table[Amount] ), ALLSELECTED ( Table ) )
)

    Regards,

    Xiaoxin Sheng

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI mdex,

You can try to use the following measure formula if they suitable for your requirement:

Measure =
DIVIDE (
    CALCULATE (
        SUM ( Table[Amount] ),
        ALLSELECTED ( Table ),
        VALUES ( Table[Role] ),
        VALUES ( Table[Date] )
    ),
    CALCULATE ( SUM ( Table[Amount] ), ALLSELECTED ( Table ) )
)

Regards,

Xiaoxin Sheng