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?
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.
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.