Forum Discussion
Matrix Preview - Disable Drill-Down when using several fields as rows
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.
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-msft9 years agoMicrosoft Employee
Hi ferzfeld,
As I tested, in Martrix preview, we are unable to achieve what you want. Thanks for understanding.
Best Regards,
Angelia