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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Newworld92
New Member

How to cluster categories on x-axis

Dear PBI Gurus,

I'm working at creating an histogram where x-axis has 2 dimensions.

I'd like to "group" or "cluster" one of the dimensions like in the example i attached where you can see 2 levels with the 1st one not being repeated all the time. It looks like it is grouped.

Do you know to manage this?

Thank you.

2 levels and the second one is not repeated, that's what i need, thx2 levels and the second one is not repeated, that's what i need, thx

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Newworld92 , if you do not have grouping create one using grouping

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-grouping-and-binning

 

In Bar visual Sort on Axis and concatenate label off

Concatenate Label off : https://youtu.be/QgI0vIGIOOk

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

2 REPLIES 2
Newworld92
New Member

Thank you. 😉

amitchandak
Super User
Super User

@Newworld92 , if you do not have grouping create one using grouping

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-grouping-and-binning

 

In Bar visual Sort on Axis and concatenate label off

Concatenate Label off : https://youtu.be/QgI0vIGIOOk

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors