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 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
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}))
2 Replies
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}))Brilliant! That worked. Thanks
