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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

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
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors