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

Chart Bar Spacing

Hello,

 

I am trying to create a chart but I can't get spacing to work between the individual bars.

 

Please see images - any help would be appreciated.

 

Billychartspacing.JPGchartspacing2.JPG

1 ACCEPTED SOLUTION
AmiraBedh
Resident Rockstar
Resident Rockstar

What type of visual you are using ? Is your Power BI updated ?
Otherwise you can find the answer here : Solved: Spacing between bars - Microsoft Fabric Community

If you update your PBI, you will find it :

AmiraBedh_0-1694683666848.png

 


Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696

View solution in original post

8 REPLIES 8
Anonymous
Not applicable

Hi all,

 

I now have my bars in the chart but the spacing doesn't work.  I've tried spacing within column but this only widens each chart.

 

How can I put gaps between my bars?barsnospace.JPG

JoeBarry
Solution Sage
Solution Sage

Hi @Anonymous 

 

Are Using Power BI Desktop? If you are from the Screenshot, it looks like an older version, best to update  to newset version.

 

To your question. Highlight the Bar Cahrt, go to format undeer Columns you will find Spacing 

JoeBarry_0-1694683460738.png

 

 

Thanks

Joe

 

If this post helps, then please Accept it as the solution

Anonymous
Not applicable

Hi,

 

That only widens the bar it doesn't put gaps between the bars - how do I do this?

AmiraBedh
Resident Rockstar
Resident Rockstar

What type of visual you are using ? Is your Power BI updated ?
Otherwise you can find the answer here : Solved: Spacing between bars - Microsoft Fabric Community

If you update your PBI, you will find it :

AmiraBedh_0-1694683666848.png

 


Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696
Anonymous
Not applicable

I'm using a clustered column bar chart - spacing within columns only widens the bars it doesn't put spaces between the bars - this is what I need help with

 

Yes my power Bi is up to date and I am using desktop

Check the link I provided you may need ti use dump measures for the spacing.


Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696
Anonymous
Not applicable

I had a look at that - so I just need to create a measure - Measure - blank() and add it between each row?

Yes exactly !


Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696

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.