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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Empty space in Column Chart

I've created a clustered column chart from 8 fields, but for some reason there is all this empty space on either side of the bars. I tried changing the width of the columns, but that simply expands the whole chart, preserving the empty space. It looks the same horizontally or vertically. There are exactly eight measures in this chart - what's going on?

 

Thanks.

 

Capture.PNG

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

I think this comes down to my data needed to be unpivoted first. Instead of 8 measures, I unpivoted the data and created one measure which I then visualize by different attributes (in this case race). Almost fixed, but having a problem with my measure which I will post separately.

 

Thanks.

 

View solution in original post

5 REPLIES 5
Anonymous
Not applicable

I think this comes down to my data needed to be unpivoted first. Instead of 8 measures, I unpivoted the data and created one measure which I then visualize by different attributes (in this case race). Almost fixed, but having a problem with my measure which I will post separately.

 

Thanks.

 

Anonymous
Not applicable

Confirmed - works fine now: 

 

Capture.PNG

 

Glad you got it @Anonymous . Indeed, unpivoting data is often the answer!

 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
amitchandak
Super User
Super User

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

 

Greg_Deckler
Super User
Super User

Well, you have cropped off the legend and the axis so tough to see what is going on. Since you apparently only have a single category in your axis, perhaps try swapping your legend to your axis?

 

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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