Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Sorry, very new to PowerBI and DAX. I'm trying to create the chart below, but I'm not even sure what to search for. All I have to show is my stacked bar, but that lacks the 100% border as the chart below has.
Solved! Go to Solution.
Just like in the picture, I doubt there's a way to achieve this with generic charts because for the label above the bar you need a cluster chart and for the filling bar effect you need a stacked chart.
If a stacked chart with the filling effect is good enough, then you can achieve it with the following steps:
1. create 3 measures :
for basic sum by category :
Next steps are dealing with format.
1. Switch off the legend and the X axis :
2. Modify bars' colors:
3. customize labels , put the absolute sum instead of percents :
From this point on, you have a little bit left to improve the design. I hope the main idea is clear
The pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Just like in the picture, I doubt there's a way to achieve this with generic charts because for the label above the bar you need a cluster chart and for the filling bar effect you need a stacked chart.
If a stacked chart with the filling effect is good enough, then you can achieve it with the following steps:
1. create 3 measures :
for basic sum by category :
Next steps are dealing with format.
1. Switch off the legend and the X axis :
2. Modify bars' colors:
3. customize labels , put the absolute sum instead of percents :
From this point on, you have a little bit left to improve the design. I hope the main idea is clear
The pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Quite a stretch for someone very new to Power Bi, but if you want to learn the technique, it is well explained by How to Power Bi: https://youtu.be/EiIAkJ9R7mM?si=mWlioob7aKt407si
Thank you, I'll watch the video. And, yes this project is definitely a few steps above my experience level, deep end learning I guess