Percentage labels on a stacked chart

[Anonymous]

Hi, 

I have the chart above that I am using. However, instead of showing the raw data values I want to show these as a percentage of that bar (i.e. the 12 would show 75% as it is 12/16). I have tried to show data as a %of grand total but all that does is show it as a total of all of them added together. Likewise, I have tried the 100% stacked chart but that doesn't show the difference in sample size which i really need to highlight. 

Thanks in advance

[v-alq-msft]

Hi, @Anonymous 

Based on your description, I created data to reproduce your scenario. The pbix is attached in the end.

Table:

You may create a measure as below.

Result = 
DIVIDE(
    SUM('Table'[Value]),
    CALCULATE(
        SUM('Table'[Value]),
        ALLEXCEPT('Table','Table'[Date].[Month])
    )
)

Result(Stacked bar chart):

Because the value of the measure for each month is 1, it doesn't show the difference in sample size. 100% stacked chart has the same result.

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[manikumar34]

@Anonymous , 

Hi, 100% stacked bar chart should work. Else you can try to claclaulte a measure and placd it on tooltips or you can have a measure on values to show on percentages. 

Could you share data or pbix by removing sesitive data.

Regards, 

Manikumar