Show Multiple Headings for nested Row in Matrix Visual

[Don-Bot]

I have a matrix visual that has "State and then County" as the values in the row.  However, in the actual visual it just says "State".  

Is there a way I can get it to actually show State and County before any expanding happens?  Besides of course manually typing it in.  

I've found these links but there doesn't appear to be a "step layout" option anymore in row headers.  Although I'm not sure that would help me anyways.

https://community.fabric.microsoft.com/t5/Power-Query/How-to-get-multiple-row-headings-to-display-on...

[samratpbi]

Hi @Don-Bot wondering why you would need your column header dynamic? As @GeraldGEmerick  has mentioned, you can rename it manually. Other option could be create a measure that would return the name what you need and then place that in a card visual on top of the column header, so that based on any selection it would change.

Hope this helps.

If this helps to solve your problem then please mark it as solution.

Thanks - Samrat

[v-menakakota · Accepted solution]

Hi  @Don-Bot 
Thanks for reaching out to the Microsoft fabric community forum. 

I would also take a moment to thank @MasonMA   , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

I tried reproducing this scenario using sample data

In Format pane-> Row headers->Turn off“+/- icons”

Set Layout = Tabular

Right-click any country, Expand all down one level in the hierarchy

Please go through the pbix file.

If I misunderstand your needs or you still have problems on it, please feel free to let us know.   

Best Regards, 
Community Support Team  

[v-menakakota]

Hi @Don-Bot  ,

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.

Best Regards, 
Community Support Team.

[v-menakakota]

Hi @Don-Bot  ,

I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.

Best Regards, 
Community Support Team.

[MasonMA]

Hi, Stepped layout no longer exists under Row headers in recent versions. You can use Tabular for Layout and switch off the '+/- icons'. for the Matrix, expand all down one level in hierarchy in the row header. 

[GeraldGEmerick]

@Don-Bot Typically you would go to your Rows area, double click on State and then rename it manually to State and County.