Power Query - Filter to List if...

[gheyman]

This is Excel Power Query

I have a table that I am filtering to another table (list). But I want the user to have the option of filtering to the list or not (otherwise no filter - show all). Is this possible?

 

[XL Pro]

Check this article from Ken Puls and see if you could adapt it to your needs: Use Excel Tables to Filter a Power Query