Forum Discussion
Modify spaces between columns in clustered column chart
I understand that, but is there a way to collapse that space and bring the other bars closer together? And for 2019 there is only Production Machine, but i would have liked the bar to be more centered with the year. It may not be possible, but wasn't sure.
Hi Scabral,
One potential solution could be to use null values rather than 0 for 2019 and 2020 for the categories Pressure Vessel. This may remove the Pressure Vessel category for these years, allowing the bars to come closer together. However, it would be important to ensure that changing the representation of data from 0 to null makes sense in your business context.
Otherwise, I don't think there is a feature in the visual that will allow you to move the bars closer together because the value of 0 in 2019 and 2020 are in fact, valid, based on your data. Thus, Power BI will represent it in the column chart.