How to show percentages on Stacked column chart? (not percent of grand total)

[Zyg_D]

This is my data:

I have this graph:

How do I make those numbers appear as percentages, like in the following pic?

"Percent of grand total" does not give the results that I want. 

[v-diye-msft · Accepted solution]

Hi @Zyg_D 

kindly check below results, pbix attached.

[Zyg_D · Accepted solution]

Since it is not clear if it's possible to obtain exactly what I originally posted, I will post the workaround solution with the code for others to use. The result looks like this:

 I have put a measure called "Percentage" into the tooltip. This is the formula:

Percentage = 
DISTINCTCOUNT ( Table1[ID] )
    / CALCULATE ( 
        DISTINCTCOUNT ( Table1[ID] ), 
        ALLEXCEPT ( Table1, Table1[Year] ) 
    )

The format had to be changed to show percentage values:

[v-diye-msft · Accepted solution]

Hi @Zyg_D 

kindly check below results, pbix attached.

[Syndicate_Admin]

Try changing the chart to one of 100% stacked bars and then placing the values as a percentage of the overall total, not the ideal aesthetic, but it's a quick and functional solution.

Best regards

[Zyg_D]

---

@v-diye-msft wrote:

Hi @Zyg_D 

kindly check below results, pbix attached.

---

Thank you, Dina, for the answer. The measure that you created can at least be added to a tooltip, which would serve as a workaround.

Isn't it possible to show percentages while keeping bar height unaffected?

[az38]

Hi @Zyg_D 

set Show value as Percent of grand total in visual Value settings

[Zyg_D]

---

@az38 wrote:

Hi @Zyg_D 

set Show value as Percent of grand total in visual Value settings

---

Thanks for the answer, but no. This gives me 20, 20, 20, 40. While I want 50, 50, 33.3, 66.7.

[Gladiator909]

@Zyg_D I am facing the same issue as you. Have you been able to get those percentages displayed on the chart?

The only work around is using the tooltips, but sometimes clients want the % displayed on the graph.. so dissapointing that PowerBI does not have that feature... on the other hand, you are able to do it in excel...