Apply 'no filter'

[Kkaushik]

Hello, I am applying filter on a column using a list (selected using dropdown). However, sometimes I don't want to filter. What should be the value in the cell so that Power Query doesn't apply filter.

My filetered column:

= Table.SelectRows(Source, each ([Manager] = MgrNameSelected{0}))

where MgrNameSelected is the selected value using dropdown. Sometimes, I want to see full data i.e. without the impact of filters. Is there a wildcard text to make the filter ineffective? Thanks

[Kkaushik]

Brilliant! That worked. Thanks  

[Payeras_BI · Accepted solution]

Hi @Kkaushik ,

What about adding ALL to the list and using a conditional:

= if MgrNameSelected{0} = "ALL" then Source else Table.SelectRows(Source, each ([Manager] = MgrNameSelected{0}))