Calculating Column/X Axis Percentage in Stacked Bar Chart

[mdex]

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 items are calculated as a % of the grand total instead.

I understand I likely need a measure to represent this but cannot think what. Any help gratefully appreciated.

[v-shex-msft · Accepted solution]

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

[amitchandak]

Can you create a new column like this and use

https://community.powerbi.com/t5/Desktop/Percentage-of-subtotal/td-p/95390

Also refer :https://docs.microsoft.com/en-us/power-bi/desktop-quick-measures

[mdex]

Those measure work if using a matrix, but I already have that showing correctly.

They still show as a % of grand total when using in a Stacked Bar chart rather than a % of the column total.