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
walker8888
Helper II
Helper II

Removing 0% that causes spaces between my bars and putting the Internal FTE's chart on top

First, I simply want to move my Internal FTE's to be on top of the External FTE's. How can I achieve this? I am pretty sure it is easy but have not found the way. Secondly anything that is 0% I will not be showing. However if I don't show it, it will leave a space between my bars and I want my bars to be together, so how can I achieve having no white space between anything that is 0%? Thanks!

 

walker8888_0-1664218460238.png

 

 

1 ACCEPTED SOLUTION
v-easonf-msft
Community Support
Community Support

Hi, @walker8888 

1. To move Internal FTE's to be on top of the External FTE's, please check the "more options"->"sort axis"

veasonfmsft_0-1664247630125.png

You can also add a custom sort column and sort column 'FTE'  by this sort column.

veasonfmsft_1-1664248389628.png

 

2.There is no direct option for us remove the blank spaces in each clustered bar/column chart.

It is by design. When you have put a filed in the Legend field, it will keep the blank spaces for consistency. 

You can consider using stacked bar chart as an alternative or create an idea here.

 

Best Regards,
Community Support Team _ Eason

 

View solution in original post

1 REPLY 1
v-easonf-msft
Community Support
Community Support

Hi, @walker8888 

1. To move Internal FTE's to be on top of the External FTE's, please check the "more options"->"sort axis"

veasonfmsft_0-1664247630125.png

You can also add a custom sort column and sort column 'FTE'  by this sort column.

veasonfmsft_1-1664248389628.png

 

2.There is no direct option for us remove the blank spaces in each clustered bar/column chart.

It is by design. When you have put a filed in the Legend field, it will keep the blank spaces for consistency. 

You can consider using stacked bar chart as an alternative or create an idea here.

 

Best Regards,
Community Support Team _ Eason

 

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