Showing results for 
Search instead for 
Did you mean: 
Budfudder Member

Power BI - Clustered Column Chart Spacing & Width

I have a Clustered Column Chart and I'm having lots of trouble getting a decent display. I have a bunch of teams (Team), each of which has up to five (5) members (Owner). So I drag the Teams field onto the chart and then the Owner field. What I get is the attached (the big red vertical line is my manual add in an image editor, just to split the two teams' columns for this post.


There are a couple of issues with this:

- the columns are so skinny. How can I widen them? I've messed about with the 'Minimum category width', 'Maximum size' and 'Inner padding' but cannot get anything that looks half decent.

- why are the gaps between the columns so irregular? For example, on the attachment to this post, in Team 5, why the large gap between the 642 column and the 305 column? They're both users in the group, the same as the 166 and the 642 columns - so why a different gaps? And how can that be fixed/changed?Image2.jpg

Community Support Team
Community Support Team

Re: Power BI - Clustered Column Chart Spacing & Width

Hi @Budfudder ,


1. We can change the width and height of the columns in the chart by this way.




2. For the 2rd question, I think that should be the issue of your blank value. You can disable the option "Show items with no data" to work on it.




If it doesn't meet your requirementn. Could you please share your sample data and excepted result to me if you don't have any Confidential Information.Please upload your files to One Drive and share the link here.




Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Budfudder Member

Re: Power BI - Clustered Column Chart Spacing & Width

Thanks for your reply. As far as I can see, your first comment on changing the width of the columns - those settings control the width and height of the entire visual, not specific columns within it. My visual is already the size of the entire page. Within it, the various columns are extremely thin.


Your second point - unfortunately changing the value of the 'Show items with no data' makes no change at all to the visual. 


I've put a Test Power in OneDrive here. It's a pbx and xlsx with dummy data illustrating the problem.

Helpful resources

Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 450 members 4,849 guests
Please welcome our newest community members: