Forum Discussion
How to create a nested double column header in a Power BI matrix visualization
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.
Try to select Drill on Columns and then click the circled button to show both column headers.
3 Replies
vicky_Super User
Try to select Drill on Columns and then click the circled button to show both column headers.
Yep, that was it. Thank you so much for the timely help!
- serpiva64
Solution Sage
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!
