Help with Drill Down Restriction

[maurcoll]

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.

[v-echaithra]

Hi @maurcoll ,

Thank you @alish_b   for your inputs.
Just following up to see if the response provided was helpful in addressing the issue. if the issue still persists feel free to reach out if you need any further clarification or assistance.

Thank you,
Chaithra E.

[alish_b · Accepted solution]

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!

[maurcoll]

Thank you i will try that

[vivien57]

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