Forum Discussion

Don-Bot's avatar
Don-Bot
Helper V
10 months ago
Solved

Show Multiple Headings for nested Row in Matrix Visual

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 Cou...
Need Help
  • v-menakakota's avatar
    v-menakakota
    10 months ago

    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  

     

samratpbi's avatar
samratpbi
Super User
10 months ago

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's avatar
v-menakakota
Community Support
10 months ago

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's avatar
    v-menakakota
    Community Support
    10 months ago

    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's avatar
      v-menakakota
      Community Support
      10 months ago

      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.