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
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?
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.
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.
Regards,
Frank
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
111 | |
103 | |
103 | |
87 | |
61 |
User | Count |
---|---|
162 | |
132 | |
131 | |
95 | |
86 |