Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
apocryphal_pnda
Frequent Visitor

How do I create this chart?

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.

 

 

bar chart.PNG

 

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

Hi @apocryphal_pnda 

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 :

Sum_ = sum('Table'[Sales])
For percent from total:
% from total = divide ([Sum_],CALCULATE([Sum_],ALLSELECTED('Table'[Team])))
For the "blank" part, the difference from 100%:
delta_from_100% = 1-[% from total]
Then put 2 last measures in the stacked graph:
Ritaf1983_0-1715365136852.png

Next steps are dealing with format. 
1. Switch off the legend and the X axis :

Ritaf1983_1-1715365273004.pngRitaf1983_2-1715365320456.png

2. Modify bars' colors:

Ritaf1983_3-1715365386604.pngRitaf1983_4-1715365434865.png

3. customize labels , put the absolute sum instead of percents :

Ritaf1983_5-1715365605632.pngRitaf1983_6-1715365639994.png

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.

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

3 REPLIES 3
Ritaf1983
Super User
Super User

Hi @apocryphal_pnda 

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 :

Sum_ = sum('Table'[Sales])
For percent from total:
% from total = divide ([Sum_],CALCULATE([Sum_],ALLSELECTED('Table'[Team])))
For the "blank" part, the difference from 100%:
delta_from_100% = 1-[% from total]
Then put 2 last measures in the stacked graph:
Ritaf1983_0-1715365136852.png

Next steps are dealing with format. 
1. Switch off the legend and the X axis :

Ritaf1983_1-1715365273004.pngRitaf1983_2-1715365320456.png

2. Modify bars' colors:

Ritaf1983_3-1715365386604.pngRitaf1983_4-1715365434865.png

3. customize labels , put the absolute sum instead of percents :

Ritaf1983_5-1715365605632.pngRitaf1983_6-1715365639994.png

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.

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile
Alex87
Solution Sage
Solution Sage

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

 




Did I answer your question? Mark my post as a solution!
Appreciate your Like/Kudos

Proud to be a Super User!




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

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors