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.
