Line and stacked column charts vs 100% stacked column chart.

[Mk60]

Is there a way to show % instead of $bn in my "Line and stacked column chart", (first example)? If I select "100% stacked column chart" from the visuals in Pbi, I can obviousely have %s, but I can't include line on the Y, (second chart)? Any way this can be done, and these two options combined, (columns as % and line on the Secondary Y axis? Any suggestion is much apprecited!

First example:

Second example:

[Anonymous · Accepted solution]

Hi @Mk60 ,
Based on the information you provided, I have tested what you want to achieve and unfortunately Power Bi does not have a visual that combines a 100% Stacked column chart with a Line chart at the moment. 

If you want to achieve a visual that combines a 100% Stacked column chart with a Line chart, You can submit an idea for it at https://ideas.powerbi.com/ideas/

There is a workaround to consider: If you want to show percentages, you can create a metric for calculating the percentage of the total set for the year and add it to the Line and stacked column chart.

Final output:

 How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Mk60]

Ada, just wanted to thank you for looking into my question. I submitted an idea, as you suggested, and apparently there were already five other users looking for the same solution. Unfortunately it would be almost impossible to provide pbix file without privacy information, althought I would love to explore the workaround option. It looks like I might just wait for some future PBI updates.