Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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.
Solved! Go to Solution.
Got it - there is an option called 'Concentrate' in the x-axis options that removes the flattening effect. Thanks ot all.
Got it - there is an option called 'Concentrate' in the x-axis options that removes the flattening effect. Thanks ot all.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!