Forum Discussion
Solved
Help with Drill Down Restriction
Hi I have a matrix visual that has 4 levels of data is it possible to restrict the drill down on the visual based on the numbers at each level. So for example if the value of one of the fields at l...
Hi maurcoll ,
The drill down cannot be controlled using conditions.
However, you might find luck in hiding the levels that have values less than a defined threshold. After selecting the matrix visual, head over to the filters pane and then add a visual level filter on the metric where you set the value to be greater than threshold (say 5). This should be the simplest.
Else, you could do it with DAX as well by returning the actual value when it is above the threshold and blank value otherwise , something like:MetricA_Final= IF([MetricA] > 5, MetricA, BLANK()Power BI automatically filters out blank values in the visual so the level associated with it will not show.
Hope it helps!
