Use Power Query Parameter to Quickly Filter

https://youtu.be/gFqlfSckc5s

This video will introduce you to using the parameter feature in Power Query. You can use parameter to pass values to other parts of your query to give interactivity to your query. This example will use a simple procedure of filtering a column to show how it works. Now filtering a column seems like overkill, but if you have a LOT of columns, scrolling across the many columns can be a hassle. Incorporating the parameter feature may make it less of a hassle.