Forum Discussion
Customize 100% stacked bar chart
Hi all,
Does anyone know how to create a 100% stacked bar chart like the one below?
Thanks!
Hi, VTork ;
You could create two measures.
percent = SUM(financials[ Sales])/CALCULATE(SUM(financials[ Sales]),ALL(financials))Measure = 1-[percent]then set it.
change the color.
and off one measure data label
The final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Hi
Picture is to small to be sure, but i think you are looking for some progressive bar charts
You can follow the ideia of this video
https://www.youtube.com/watch?v=1TXDFH83uV8&ab_channel=ExcelFort
Kind regards,
José
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂Hi José,
Thank you for getting back to me! Sorry didn't realise how small it was when I uploaded it.
Please see below.... If possible, I'd like to create an identical chart as the one below in Power Bi.Many thanks!
Hi, VTork ;
You could create two measures.
percent = SUM(financials[ Sales])/CALCULATE(SUM(financials[ Sales]),ALL(financials))Measure = 1-[percent]then set it.
change the color.
and off one measure data label
The final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
