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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
Arkhos94
Helper IV
Helper IV

Reduce stacking in clustered bar chart

I have the following bar chart :

Capture.PNG

Each bar is a different value (all in %)

 

I like the chart but it's too clustered and most of the space is empty. I would like to increase the space between the chart but I can't find the option.

 

Is it possible to increase the space between the bar somehow (and use the whole space instead of just the center) ?

2 ACCEPTED SOLUTIONS
amitchandak
Super User
Super User

@Arkhos94 , there is padding option. But not sure it can help much here.

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

v-kelly-msft
Community Support
Community Support

Hi @Arkhos94 ,

You can try adjusting these values under X-axis:

v-kelly-msft_0-1608536319314.png

And you will see:

 

v-kelly-msft_0-1608536633968.pngv-kelly-msft_1-1608536649078.png

 

 
 

 

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

View solution in original post

7 REPLIES 7
v-kelly-msft
Community Support
Community Support

Hi @Arkhos94 ,

You can try adjusting these values under X-axis:

v-kelly-msft_0-1608536319314.png

And you will see:

 

v-kelly-msft_0-1608536633968.pngv-kelly-msft_1-1608536649078.png

 

 
 

 

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

AllisonKennedy
Super User
Super User

@Arkhos94 , Ah yes you did not mention that they were all different measures. Measures can only go in 'Values'. You could try a custom visual if you're comfortable using those? https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals&search=column&page=1 They often have more formatting options available. 


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

Arkhos94
Helper IV
Helper IV

@amitchandak : the padding allowed me to make it a bit bigger. That's not perfect that's already a bit better

@AllisonKennedy : all of my values are custom measure (like market share, percentage of objective done...13 different measure right now and likely up to 16/20 when I will be done). I tried putting them in legend or axis but power bi doesn't accept

AllisonKennedy
Super User
Super User

@Arkhos94  You could put the same column in Legend and Axis: 

 

AllisonKennedy_0-1608288654750.png

 


Please @mention me in your reply if you want a response.

Copying DAX from this post? Click here for a hack to quickly replace it with your own table names

Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com

amitchandak
Super User
Super User

@Arkhos94 , there is padding option. But not sure it can help much here.

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube
Arkhos94
Helper IV
Helper IV

Hello,

 

I didn't use any axis value. I have all my KPI's in the value part of the chart and nothing in axis or legend

amitchandak
Super User
Super User

@Arkhos94 , I doubt you can do much about that. Have used any Axis values?

If not then move legend value to axis

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

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