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, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
A_Scott
Helper I
Helper I

Why is my Clustered Column Chart so crammed together?

I am trying to display a column chart to show the percentage result from several questions in a survey. Each column is a measure. I'm not spl.itting it by location or anything. I just want to see the overall total of each column. Why is so crammed together? I have adjusting spacing, column width, making my canvas larger and in turn making the visual larger. Nothing makes the columns larger or spaced out enough.

A_Scott_0-1682599185163.pngA_Scott_1-1682599199913.png

Changing spacing does nothing visually

A_Scott_2-1682599273481.png

 

 

2 REPLIES 2
Ashish_Mathur
Super User
Super User

Hi,

From the image that you have shared, it looks like your data is not well structure.  I think you need to use the "Unpviot Other Columns" feature in the Query Editor. 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
lbendlin
Super User
Super User

The padding and spacing settings are working across clusters. You only have a single cluster. This is working as designed.

 

Instead of cramming all the measures into a single cluster, have a bucket table and then calculate the measure for each bucket.

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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