How to create a nested double column header in a Power BI matrix visualization

[autodafey]

Here's an example of what I'm trying to make from an Excel Pivot Table with the same data.

I created a matrix visualization that has the following where HR Status is the "Accrual" and "Used" data from the Pivot Table above.

However, when I drop two columns into the Visualization (expecting it to nest them like a PivotTable), it only shows the one.

And when I reverse the order, it just still shows only the one on top.

How do I get it to show both, like the Pivot Table does?  I feel like it's something simple and I'm just missing it.

[vicky_ · Accepted solution]

Try to select Drill on Columns and then click the circled button to show both column headers.

[autodafey]

Yep, that was it.  Thank you so much for the timely help!

[serpiva64]

Hi,

if this is what you need

You have to create a matrix

then drill on rows

and finally drill on columns

If this post is useful to help you to solve your issue, consider giving the post a thumbs up and accepting it as a solution!