Forum Discussion

ferzfeld's avatar
ferzfeld
Advocate II
9 years ago

Matrix Preview - Disable Drill-Down when using several fields as rows

Hello,

 

I really love the new Matrix Preview feature as it lets me filter my other visuals by clicking on a row in that matrix.

 

When I add several fields as rows, it will only let me use the drill-down functionality. I need the fields I added to the rows showing next to each other.

 

Is there any way to disable the drill-down functionality?

 

As a work-around I created a column concatenating the fields I need to show in a row, but it is bad for readabilty.

 

Thank you!

 

- Frank

5 Replies

  • dsynan's avatar
    dsynan
    Advocate III

    Go into the Format menu on the visual and disable "Stepped Layout" under the Row headers menu. Then go to your First row header/or conten under the first row header and "expand to next level" until you get your desired row headers. 

    • ferzfeld's avatar
      ferzfeld
      Advocate II

      Hi dsynan,

       

      Thank you for your feedback. Expanding to the next level is getting me closer to the desired result, but still not providing the presentation of the data I need.

       

      I created 2 screenshots to help understanding my problem:

       

      1. Using the table visual which provides the correct presentation of the data (and correct sort-order). It does not provide the functionality to select a value and filter my visuals by this value.

       

       

      2. Using the matrix preview visual and expanding to the next level. The sort order of my rows is not as intended (grouped by OP)

       

       

       This is probably the intended behaviour of the matrix visual, I am only using the visual because of the possibility to mark rows and use them as filter for my other visuals.

       

      Thank you in advance!

      - Frank

       

      • v-huizhn-msft's avatar
        v-huizhn-msft
        Microsoft Employee

        Hi ferzfeld,

        As I tested, in Martrix preview, we are unable to achieve what you want. Thanks for understanding.

        Best Regards,
        Angelia

    • Anonymous's avatar
      Anonymous
      Not applicable

      THANK YOU!  

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee

    Hi ferzfeld,

    Have you resolved your problem? As I tested, you can use "Stepped Layout" option to set a hierarchy beneath as dsynan posted. More details, please review this article.

    If you have other issues, please feel free to ask.

    Best Regards,
    Angelia