cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kkaushik
Frequent Visitor

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

1 ACCEPTED SOLUTION
Payeras_BI
Solution Sage
Solution Sage

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}))

 

If this post answered your question, please mark it as a solution to help other users find useful content.
Kudos are another nice way to acknowledge those who tried to help you.

J. Payeras
Mallorca, Spain

View solution in original post

2 REPLIES 2
Kkaushik
Frequent Visitor

Brilliant! That worked. Thanks  

Payeras_BI
Solution Sage
Solution Sage

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}))

 

If this post answered your question, please mark it as a solution to help other users find useful content.
Kudos are another nice way to acknowledge those who tried to help you.

J. Payeras
Mallorca, Spain

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors