Results 1 to 8 of 8

Thread: Dynamic Filter in Power Query

  1. #1

    Dynamic Filter in Power Query



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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?

  2. #2
    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.

  3. #3
    That did not seem to post the attachment - let's try again....
    Attached Files Attached Files

  4. #4

    This is EXACTLY what I wanted! THANK YOU!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!


    Quote Originally Posted by Brian Smith View Post
    That did not seem to post the attachment - let's try again....

  5. #5
    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.

  6. #6
    Neophyte jewelmary's Avatar
    Join Date
    Oct 2019
    Posts
    1
    Articles
    0
    Excel Version
    professional 2016
    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

  7. #7
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,281
    Articles
    0
    Excel Version
    Office 365 Subscription
    Please start your own thread.
    Ali
    Enthusiastic self-taught user of MS Excel!

  8. #8
    Seeker RonaldLieuw's Avatar
    Join Date
    Sep 2019
    Posts
    11
    Articles
    0
    Excel Version
    2010
    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 by RonaldLieuw; 2019-10-19 at 06:00 PM. Reason: I found the solution

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •