Clear Drill Through Filter

Hi,

This thread is a bit dated, but since I fell into this "trap" today and failed to find an answer when searching for it, I thought I could share how it happened and how I solved it:

I casually tested the tooltip drilling function (which I found out about today), which then had me fooled when I published a report having the drilling level accidentally set to the way the report is set by default.

When checking the report in the service, the filter was "locked" to one filter value, thus making it impossible to change this very filter value in the filter pane.

The solution in my case was to identify the visual in which I had performed the drill-through/drill-down, which was a tablix visual.

I selected the visual, hovered over it and used the visual's Header Icons to drill-up to top level again.

This way the "filter lock" was released.