Forum Discussion
rschaudhr
Resolver II
4 years agoMatrix visual expand automatically when hierarchy filter is applied
I have a question. I have a matrix visualization and the rows can be drilled down (expanded). I also have a hierarchy filter that represents rows in the maxtix viualization. The image of the this is ...
MFelix
Super User
4 years agoHi rschaudhr ,
To my knowledge there is no possibility of making the drill down based on the slicer selection, slicers are for filtering data not drill dow/up.
If you have the matrix drill down to the lowest level then the slicer will filter to that specific record. So if you force the matrix to always be on the lowest level when you go to that report page then using the filter will implement the desired filtering.
You can also try a custom visual that allows to have filters directly on your matrix:
https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381371?tab=Overview