Forum Discussion

Humpjs's avatar
Humpjs
Advocate I
9 years ago

Option to Disable Drilldown on Matrix

Is there an option to disable the drilldown functionality of a Matrix?   I like it the matrix because of the way it looks and the way I can organize it, but I don't want the user to be able to drill down.

Need Help

1 Reply

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    9 years ago

    Hi Humpjs,

     

    Depending on how many data you want the end user to see, you can just place the useful data in the matrix.

     

    If you only put one column to Rows or Columns section of the matrix visual, there is no drill down on row headers or column headers.

     

     

    If you put multiple columns to Rows or Columns section, you can expand all levels data. The user needn't to drill down to see each level data, but they can drill up to see above level. As the user can see all level data, it shouldn't be a concern that user can drill down/up.

     

     

    Reference:
    Use the new Matrix visual in Power BI Desktop

     

    Best Regards,
    QiuyunYu