Clear All Slicers Button also clearing direct query filters

[MannyJ]

Hi everyone.

I have a report displaying the power consumption of multiple properties. I used a direct query for my data source and there is a filter on specific properties on the direct query. On the report page I have slicers for date, relative date, and for property.

I applied the 'Clear All Slicers' button to my report, and when I click on it all the slicers clear. The problem is that it also clears away the property filters put on the direct query. Now the property slicer is displaying all the properties that were filters out on the direct query. How can I fix this?

Thank you.

[lbendlin]

 there is a filter on specific properties on the direct query

is that a mandatory filter?  If so, mark it as locked. Better yet, filter at the source.

is it something that users can modify? Like a default setting?

[MannyJ]

Hi @lbendlin, I placed the filter on the direct query using power query. The filter only allows data from specific properties to come into the model, not all the properties. I would share the screenshots, but it's sensitive customer data so I cannot do that unfortunately. Is the a way I can lock it on Power Query?

[lbendlin]

If you use the filter in Power Query then your report users cannot modify it.

[MannyJ]

When I click the 'clear all filters' button on the report, it clears the filter that was put on the direct query as well. So instead of the report to just show 3 properties (according to the filter put into power query), it shows all of the properties. I hope that makes sense.

[lbendlin · Accepted solution]

Yes but if you incorporate these filters in the actual query then they will always apply.