Forum Discussion
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 level 3 is less than 5 then either the field with the value of less than 5 wont be visible or you can't drill down to that level.
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!
4 Replies
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!Thank you i will try that
Hello,
No, that's not possible for me. At best, you can create a DAX measure to hide the values (for values less than 5).
have a nice day,
Vivien
