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 d...
Need Help
dsynan's avatar
dsynan
Advocate III
9 years ago

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
    9 years ago

    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
      9 years ago

      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
    8 years ago

    THANK YOU!