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

[Melih]

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 :

[suparnababu8]

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-B...

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

Thanks!

[lbendlin]

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