Showing results for 
Search instead for 
Did you mean: 
Humpjs Frequent Visitor
Frequent Visitor

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.

Moderator v-qiuyu-msft

Re: Option to Disable Drilldown on Matrix

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.




Use the new Matrix visual in Power BI Desktop


Best Regards,


Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.