remove the filter on a field parameter in a visual

[techpowerbi]

HI, I need a solution for this problem.

I have a field parameter to show the columns of a table.

I have a standard state where UU is the only column to show

When a condition is fulfilled (myVariable is True) the filter on the visual should be removed. 

How to remove the filter on a field parameter in a visual?

Thks

[v-yueyunzh-msft · Accepted solution]

Hi ,  @techpowerbi 

According to your description, you want to realize the "When a condition is fulfilled (myVariable is True) the filter on the visual should be removed".

And now you put the filter on the "Filter on this visual" .

First of all, the function of "Filter on this visual" is to filter the visual that you want to display by default, and the function of automatic modification cannot be realized, only manual modification can be performed.

For this , you can refer to :
Filters and highlighting in Power BI reports - Power BI | Microsoft Learn

Add a filter to a report in Power BI - Power BI | Microsoft Learn

 

Secondly, for the Power BI slicer, there is currently no automatic clearing of the selected function according to the situation.For your needs, you can try to use Custom visual to see if it can meet your needs. Preselected slicer can select the corresponding value by default according to clearing.

For this , you can refer to my case before:
Solved: How to set last 2 months as default filter in a po... - Microsoft Fabric Community

 

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[lbendlin]

That's a bit of a corner case usage scenario but if this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41