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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Budfudder
Helper IV
Helper IV

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

3 REPLIES 3
spease
New Member

No response(s) to this problem?    I'm also seeing random white space being insterted in my visualization(s).    Only cure I've been able to find - is to re-create the entire visualization from scratch . . . . . . . problem is that the problem recurs after several months of updating.

v-frfei-msft
Community Support
Community Support

Hi @Budfudder ,

 

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

 

Capture.PNG

 

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.

 

2.PNG

 

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.

 

Regards,

Frank

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

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 BI.zip in OneDrive here. It's a pbx and xlsx with dummy data illustrating the problem.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.