Forum Discussion

AprilD's avatar
AprilD
Regular Visitor
9 years ago
Solved

Where is the Old Matrix Table visual?

Hello,

 

Previously the old Matrix table visual works best for my report. Then on June 2017 the updates included the New Matrix Table preview which helps to bring a new approach on the table. It shows a drill down option for the table. Therefore your have variation of Matrix Tables. That was great as we have more options to show the data. However, on July 2017 updates, the Old Matrix Table was no longer available, and remains the June Matrix Table preview. I oftenly use the Old Matrix Table as it shows at the very first glance the Sub Categories without the need of drill down option.

 

My question is, where is the old Matrix Table visual? Or is there a way where I can show a Table with Sub Category without clicking the a drill down?

 

Your response would be highly appreciated.

Need Help
Show and Tell
  • MFelix's avatar
    MFelix
    9 years ago

    Hi AprilD,

     

     

    The old Matrix visual was replaced by the new one however you can have the same look in your matrix if you follow this steps:

     

    - Format

    - Row Headers

    - Stepped layout off

    - On the table select the At the lowest level of data:

     

    Also reference to this link to more informations.

     

    Regards,

    MFelix

10 Replies

  • MFelix's avatar
    MFelix
    Super User
    9 years ago

    Hi AprilD,

     

     

    The old Matrix visual was replaced by the new one however you can have the same look in your matrix if you follow this steps:

     

    - Format

    - Row Headers

    - Stepped layout off

    - On the table select the At the lowest level of data:

     

    Also reference to this link to more informations.

     

    Regards,

    MFelix

    • aminebelghazi's avatar
      aminebelghazi
      Regular Visitor
      9 years ago

      Hi MFelix; 

       

      thanks for the workaround. 

      However, if I add a new level of hierarchy allowing user to drill down; coming back to first configuration is painful...any idea?

    • Wilsonf's avatar
      Wilsonf
      Advocate I
      9 years ago

      Hello MFelix,

       

      What is the solution for Power BI online ?

       

      I cannot see that option under Row Headers in the Online Version.

       

      Thanks

      • MFelix's avatar
        MFelix
        Super User
        9 years ago

        Hi Wilsonf,

         

        It's on the same option Row HEader, however first of all you need to select the matrix visual again, if you choose your matrix you will see no visual is selected on the right side of the screen, selected and then go to options.

         

         

        Regards,

        MFelix

  • skkelly's avatar
    skkelly
    Frequent Visitor
    9 years ago

    Hi,

    I'm having the same problem where I need to see the subcategories but my format menu doesn't have a Row Headers option:

    I can only see:

     Edit Interactions | Bring forward | Send backward | Align | Distribute.

     

    Does anyone have any ideas?

     

    SK

    • MFelix's avatar
      MFelix
      Super User
      9 years ago

      Hi skkelly,

       

      The format option that is refered is on the visual not on the toolbar.

       

      Regards,

      MFelix

      • skkelly's avatar
        skkelly
        Frequent Visitor
        9 years ago

        Hi MFelix,

         

        Thanks for your reply! I saw on one of the previous replies that the drill down button was highlighted. Should I be able to right click on the visual to get formatting options (I can't right click on it).

         

        sk