Filtering based on a dropdown list in Power Query

[stags81]

Hello,

I am using Power Query to pull multiple data sets into a single workbook. I have a table within that workbook that contains a dropdown. What is selected in that dropdown determines how the data pulled in by Power Query gets filtered. See attached for further explanation.

It works perfectly, but I'd like to take it to the next level. If a user selects "All" in the dropdown, I would like Power Query to simply disregard the input variable and display all rows. Is this possible to write in M code?

e.g.
#"Filtered Rows" = Table.SelectRows(#"Reordered Columns1", each if ([Supplier Name] = "All" then Table.DisplayAll else [Supplier Name] = Supplier)),

If more info is needed, please don't hesitate to ask. I'm just trying to be mindful of the information I share here.

Thanks in advance,

Mike

 

[billszysz]

#"Filtered Rows" = if Supplier = "All" then #"Reordered Columns1" else Table.SelectRows(#"Reordered Columns1", each [Supplier Name] = Supplier),

 

[stags81]

Thank you!