topic Re: Stacked chart with "%" in Total Values, instead of "absolute Value" - Possi in Custom Visuals Development Discussion

Stacked chart with "%" in Total Values, instead of "absolute Value" - Possible ???

Melih — Sat, 11 Jan 2025 17:40:02 GMT

Hey everyone,

i have been trying to solve a problem for days. Unfortunately in vain. 😩That's why I'm contacting you in the hope that someone can help me. In the picture you can see a stacking chart which is divided into 3 categories. The values are average values for each category. I activate the TOTAL VALUES. Here we have the absolute Values ( 2022 = 24, 2023 =25, 2024 = 24). But i need the average in the TOTAL VALUES. For example in 2022 : Instead of the Total Value of 24 i need 33% (Average of the Categories 21%, 29% and50%).

So i need a stacking chart that show the average of the categories and the average of them as percentages in the TOTAL VALUES for every single year. I hope sooooo much, that you can help me. 🙏

Thank you in advance.

Kind regards,

Melih

Current Situation:

I Need This :

Re: Stacked chart with "%" in Total Values, instead of "absolute Value" - Possi

lbendlin — Wed, 15 Jan 2025 01:18:14 GMT

Sure. Use a combined Line and stacked Column chart. Put your percentage in the line, hide the line itself but show its data labels.

Re: Stacked chart with "%" in Total Values, instead of "absolute Value" - Possi

suparnababu8 — Mon, 27 Jan 2025 07:30:20 GMT

Hi @Melih

I think it's not possible in Power BI currently. Could you please go through this accepeted answers.

https://community.fabric.microsoft.com/t5/Desktop/How-can-I-display-values-in-Power-BI-100-Stacked-Bar/td-p/911145

https://community.fabric.microsoft.com/t5/Desktop/Display-total-on-top-of-stacked-chart/m-p/6697

Thanks!