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 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-the-same-row-in-a/td-p/3241698

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  

     

6 Replies

  • 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.

  • MasonMA's avatar
    MasonMA
    Super User
    10 months ago

    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.