Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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}))
Brilliant! That worked. 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}))