Search code examples
textchartspowerbihierarchyx-axis

Display stacked x-axis text field hierarchy instead of drill down in Power BI

I'm new to Power BI & am sure there's a simple answer, like a setting or something... Need to display all fields stacked in x-axis at once, instead of having to drill down through any layers. In excel pivot table it does this automatically (please click for pic)

pivot chart

But I'm struggling to figure this out in Power BI, seems like only date hierarchies display neatly, how can I show tidy hierarchies on the x-axis with text fields? (please click for pic)

Power BI stacked x-axis

Thanks very much in advance for your help!

Solution

  • Use this arrow in the upper right corner of every visual (chart) enter image description here

    To cancel concatenation of x-axis labels: Format/ X Axis / Concatenate labels OFF enter image description here