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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Allow configurable gap width between columns/bars in all of the Column/Bar Chart types

Without control over spacing of columns and bars, data labels can overlap each other and aesthetically, the chart looks cramped. Please add a configurable spacing parameter like the "gap width" in Excel charts to allow for better visual control.
Status: Completed
Comments
kevin_young
New Member
Please, can we get this fixed. We need the ability to adjust between the inner bars!
peter_drinkwate
New Member
The person that has marked this as complete seems to have misunderstood the issue. I still have the same problem and none of the axis options etc. have much of an impact.
Cihan_Can
New Member

It is really annoying that we cannot control the spacing in a basic bar chart.

GDPR-aRalAT6CoU
New Member

Yeah this ain't workin! Much like my grammar....

fbcideas_migusr
New Member

well solution provided is correct however it does not work for many and reason for that is simple.


cluster column chart bars shows is supposed to render categorical data and not contineous data. if you can catogories data and add that category field in column legend well then you can adjust spacing and width.


for example



if you have quarter on x axis and month as column legend then for each quarter you expect 3 bars in clustered column bar with some spacing and then next quarter, however clusted column chart will display 3 bars but white space for 9+1 more bars. as a quarter has only 3 months data and for rest 9 months it render 0 value which looks like white space.


a year data -> 4 quarters -> 12 months(means 12 category)


Work around to fix this -> make new field as 'month category' which includes only respective months for quarter.


a year data -> 4 quarters -> 3 months type( means 3 category)


3 months type would be ->

m

month 1 ->which represnt first month of a quarter -> Jan, Apr, Jul, Oct

month 2 -> which represnt second month of a quarter -> Feb, May, Aug, Nov

month 3 -> which represnt third month of a quarter -> March, June, Sep, Dec


now keeping this month type field in 'column legend' well will display 3 bars and one white space for each quarter





ethan1
New Member

This is still not solved for in 2023 as far as I can find. There's no way to make the padding between bars smaller. The heck.

Tom_Augustsson
New Member

"...finally inner padding controls the gap between the bars in proportion to the bar size. "


When looking at the Line and Clustered column chart, I cannot see this control setting in the X-axis format settings.

fbcideas_migusr
New Member
Status changed to: Completed