How to create Data Label as Percentage or have it in the info box when you hover the stacked bar

[nguyenh7]

Hi everyone! How do I display the total percentage as the data label instead of total count for the stacked bar  (horizontal/vertical)? I don't want the 100% stacked bar chart, only the one that this visual shows. I've already used the tooltips to get the %GT and it does show when I hover each part of the stacked bar, is there a way to add the total percentage to the back text box under %GT when we hover over a part of the stacked bar as well?

Thanks a bunch!

[parry2k]

@nguyenh7 you need to create a measure that calculated the % and then use that measure for your line chart.

Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[nguyenh7]

I'm new to power bi, do you mind letting me know how to create a measure for that? Thanks!

[v-kelly-msft · Accepted solution]

Hi  @nguyenh7 ,

Create a measure as below:

percentage = DIVIDE(SUM('Table'[Value]),'Table'[Allocated])

And you will see:

For the related .pbix file,pls see attached.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!