Hello,
I have been using parameter tables everywhere after watching 7.01 "Parameter Tables for filtering" in the power query course.
I am wondering how or if I am able to have multiple parameters listed in the table and how I do this.
For example, from the example file is there a way I could have the user select "UK" and "USA" Regions and "Sales" and "Technology" Departments?
Thank you
Maree
Hi Maree,
Not that easily 🙂 I would give the user Slicers for the Table if you want them to be able to chop and change what they see. This will be quicker than having to refresh the query based on different filters (parameters).
If you want to have a go at the Power Query option please see this post.
Mynda
Damn - yes, they already have a slicer.
I just wanted to give them control to filter the data so that it is secure when passing it onto external sales forces. I think Chris' solution is a little advanced for me just yet.
Thank you Mynda
Maree
Maybe it's easier to teach them how to use the filters in Power Query 😉
