Stacked bar chart with percentages

[AnetaK]

Hello,

I have a stacked bar chart with number values (the one on the left).

I want to change it to show percentages.

What I get is a chart with bars of the same lenght (the one on the right).

And what I want to achieve is to be able to show the differences between the sizes of particular bars.

Is it possible?

[v-yiruan-msft · Accepted solution]

Hi @AnetaK ,

You can create a measure as below to get the percentage first and put it on the visual to replace the Values field. Please find the attachment for the details.

Percentage = 
VAR _sumofallvalues =
    CALCULATE ( SUM ( 'Table'[value] ), ALLSELECTED ( 'Table' ) )
VAR _sumofpervalue =
    SUM ( 'Table'[value] )
RETURN
    DIVIDE ( _sumofpervalue, _sumofallvalues )

Best Regards

[Anonymous]

Hello @AnetaK 

This link may help you.

[amitchandak]

@AnetaK , refer if this old solution can help

https://community.powerbi.com/t5/Desktop/Showing-percentage-values-in-Stacked-Column-Chart/td-p/1697...

[AnetaK]

Seems to be a complicated measure.

I have one simple count measure that I want to show - no weeks, no calendars...