Forum

Filter table based ...
 
Notifications
Clear all

Filter table based on user filtered values

3 Posts
2 Users
0 Reactions
91 Views
(@jaryszek)
Posts: 177
Reputable Member
Topic starter
 

Hi Guys,

i want to give possibility to user to filter one column table from form and checkboxes. 
User will choose specific options and based on that table will be filtered, or created, or...

I would like to join this table with my source table based on choosen values from user. 
So restrict Source table with choosen values by user. 

How can i do this using power query? 
Should i create separate table and use it as inner join?
Or maybe there is possibility to get filtered table values as source into power query? 

I know that i can filter in PQ but i have to somehow pass to PQ what i want to filter and use.

Please help,
Best,
Jacek

 
Posted : 08/02/2019 4:20 am
(@debaser)
Posts: 836
Member Moderator
 

Assuming you can't simply apply the filter to the PQ output, here's one method per Chris Webb:  https://blog.crossjoin.co.uk/2015/03/09/using-excel-slicers-to-pass-parameters-to-power-query-queries/

 
Posted : 08/02/2019 8:31 am
(@jaryszek)
Posts: 177
Reputable Member
Topic starter
 

Thank you very much, working like a charm!

Best,
Jacek

 
Posted : 09/02/2019 8:12 am
Share: