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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Dewiethedeck
New Member

2 or 3 level x axis categories - how to?

Hi there, 

 

I am trying to build a clustered column chart on Power BI desktop, and am running into trouble with the parameters I am adding to the X Axis section.  Specifically, I'd like to include 3 levels on the X axis -> country, office and fiscal year.  I am able to add them to the presentation but the defaul behavior is to only show one value at a time, and then requires drill down / drill up between the levels. 

 

How do I configure this so I can 2 or 3 of the levels simultaneously in a nested format?  On Excel pivot table charts connecting to the same data set, I can nest them on the same graph, so that Country acts as a container for the Office items, and then each fiscal year is an attribute of the Offices. 

 

The closest I've been able to find in Power BI is the Expand next Level option in the Data/Drill group, although this flattens the series, and cancels out the intention of showing the items in a heirarchical order that they are added to the Axis section.  

1 ACCEPTED SOLUTION
Dewiethedeck
New Member

Got it - there is an option called 'Concentrate' in the x-axis options that removes the flattening effect.  Thanks ot all.  

View solution in original post

1 REPLY 1
Dewiethedeck
New Member

Got it - there is an option called 'Concentrate' in the x-axis options that removes the flattening effect.  Thanks ot all.  

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors