topic Re: Display value and percentage in stacked bar chart in DAX Commands and Tips

Display value and percentage in stacked bar chart

apohl1 — Mon, 29 Aug 2022 07:38:41 GMT

Hi all,

Does any of you know if it's possible to show both values AND percentage in a stacked bar chart? As an example, in the chart below, I'd like it to show 28% next to 30M, and 72% next to 79M.

Thank you in advance!

Re: Display value and percentage in stacked bar chart

amitchandak — Mon, 29 Aug 2022 07:59:00 GMT

apohl1 , this video has one solution , check if that can help

Change Data labels
https://www.youtube.com/watch?v=un4PkoGF3YM

Re: Display value and percentage in stacked bar chart

apohl1 — Mon, 29 Aug 2022 08:02:34 GMT

Thanks for your message, but I'd like to show value and percentage at the same time, so unfortunately not a solution.

Thanks anyway!

Re: Display value and percentage in stacked bar chart

v-cazheng-msft — Thu, 01 Sep 2022 02:20:29 GMT

Hi apohl1,

Currently, we are not able to display values along with percent in a Stack bar chart at the same time. You may consider these solutions.

1 Voting for similar ideas in Power BI ideas: https://ideas.powerbi.com/ideas/search-ideas/?q=values%20and%20percent%20%20stack%20bar%20chart

2 Take the solution from the super user d_gosbell in this post: https://community.powerbi.com/t5/Desktop/Stacked-Bar-Chart-Percent-AND-Count/m-p/632510

3 Consider Tootip, the solution from v-cherch-msft in the same post above

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please let me know. Thanks a lot!

Best Regards,

Community Support Team _ Caiyun

Re: Display value and percentage in stacked bar chart

apohl1 — Mon, 05 Sep 2022 06:28:36 GMT

Thank you for your reply! At least it confirms what I'd like to do is currently not available. I will vote for this idea to be implemented hopefully soon.

Re: Display value and percentage in stacked bar chart

Bijen_Shah — Fri, 27 Oct 2023 13:42:08 GMT

Indeed , It is possible with some Power BI measures magic. apohl1 v-cazheng-msft amitchandak

I created 3 measures:
1. Count = COUNTROWS('Table')
2. Count % =

DIVIDE([Count],

CALCULATE(COUNTROWS('Table'),ALLSELECTED('Legend'))

)
where Legend -> i had the category column showing buy/sell trades

3. Count Concat = [Count] & " (" & ROUND([Count %],2) * 100 & "%)"

Use the "Count Concat" measure in the Data Labels -> Values -> Custom Label field.

Screenshot of my solution:

Let me know if this works for you!!

Re: Display value and percentage in stacked bar chart

Camila_Bomfim — Fri, 08 Dec 2023 11:56:48 GMT

Thanks, it worked!

Re: Display value and percentage in stacked bar chart

Bijen_Shah — Fri, 08 Dec 2023 14:27:01 GMT

apohl1
Did I answer your question? Mark my post as a solution!
Appreciate your Kudos!! Happy to Help!

Re: Display value and percentage in stacked bar chart

P207610 — Thu, 15 Feb 2024 23:47:44 GMT

This is very elegant!