Dynamic Filter in Power Query

S

Sgligori

New member
Joined
Apr 11, 2016
Messages
2
Reaction score
0
Points
0
I created an Excel dashboard for end users to see the details of their particular category. The data is based off of a table with millions of rows in Power Query.

Is there a way I could include a filter for end users to select their category and have power query filter for only that data to bring over into their report?
 
Please see attached for one way to do this.

The yellow cell is a drop down that is linked to the filter in the query. All that I did was to create that simple parameters table and drill down to the value that is selected. Then that query becomes the filter value in the "ThingsTable" query. So to the user they would just need to select the drop down and refresh.
 
That did not seem to post the attachment - let's try again....
 

Attachments

  • FilterFromDropDown.xlsx
    19.3 KB · Views: 891
You're welcome. Glad it is helpful. Chris Webb (I think) had a neat way of doing this with a combination of slicers and using the aggregate function to determine when a row in a table was visible. You could also link the query to power pivot and apply slicers tof it.
 
Hi Brain,

I also have a similar usecase where i have a master list of all companies records and i need to filter out top (n) applications of each company. Please bear in mind that the support cap varies for each company. Can we accomplish this using power query. I am new to power query.Kindly advise

Regards
Jewel
 
Never mind, I found the solution. I needed to refresh the table!

Brian, hi.
It this functionality tied to an Excel version? I am using 2010 and the filter in the yellow cell does not work!
I
 
Last edited:
You must log in or register to reply here.
Back
Top