Parameter no filter

[cknnugget]

So my forum and video search have come up empty. I'm trying to filter a query with a parameter (Cell A1 which is a drop down). I can find how to make it work for a single parameter; however, also want the user to be able to select all parameters to show on the query so nothing is filtered in the column? Does anyone know how to show all?
This is the video I was using to build the single parameter filter.

 

[alansidman]

Look at Mark's solution for your issue

Filter All in Power Query - Excel Off The Grid

Filtering in Power Query reduces the table to include only those items which meet specific criteria. However, Power Query doesn't have an option to filter to

exceloffthegrid.com

 

[cknnugget]

Thank you, I saw that video and read the title wrong and skipped over it. My mistake. It was exactly what was needed.