Show Percentage in lables in Stacked Column Chart

[Paramjit]

Hi Team,

There is a requirement to show the percentage in Stacked Column Chart.

Category	SubCategory	Value
A	Chair	100
B	Table	200
C	Mirror	300
A	Crockry	400
B	Lamp	500
C	Fan	600

Below graph is showing the lables in numbers. Requiement is to show the percentage instaed of numbers.

Percentage should be by Category (not by Grand total).

And size of bars should not change.

I am able to create custom column to get the percentage but when i am using that custom column , graph is changing to 100% stacked chart.

As below, Graph is changing to 100% stacked chart.

Thank you,

Paramjit.

[Anonymous · Accepted solution]

Hi @Paramjit ,

Try this measure

Measure = var _totalbycategory=CALCULATE(SUM('Table'[Value]),ALLEXCEPT('Table','Table'[Category]))
return DIVIDE(SUM('Table'[Value]),_totalbycategory)

Best Regards,

Stephen Tao

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

[Paramjit]

Hi  @Anonymous , as in your grpah it is changing to full stack chart. the requirement is to retain the bars lengh as when it shows using numbers. it is possible in Tableau but i am not able to get the same in Power BI.

[Paramjit]

Team, Any help on this issue please.

[amitchandak]

@Paramjit , You need to plot a visual on %  of subtotal column

divide(sum(Table[value]) , calculate(sum(Table[Value]), removefilters(Table[SubCategory]) ) )

Plot that on visual

[Paramjit]

@amitchandak  it is returing the data as below:

Column 2 = CALCULATE(SUMX(Sheet1,Sheet1[Value]),ALLexcept(Sheet1,Sheet1[Category]))

Column 3 = CALCULATE(SUMX(Sheet1,Sheet1[Value]),ALLexcept(Sheet1,Sheet1[Category],Sheet1[SubCategory]))

column = divide( Sheet1[Column 3],Sheet1[Column 2])

above custom "column" is returing the correct percentage. But stacked chart is changing into 100% chart.

Please help.