Forum Discussion
Solved
Apply 'no filter'
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 filte...
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}))
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}))