cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
sk2019 Regular Visitor
Regular Visitor

Filter table through list query

 

 

I have created a list query which holds only one value. i want to use that value to filter another table.

But Filter accepts only Parameter or manual selection and not a query.

when i want to assign this value to parameter its not taking that value instead it asks for current value. ( here i want it should take the value from the query as is, becuase that value will be dynamic.

How to do this? Please assist..

 

List Created:

list.PNG

 

Unable to assign this value to Parameter:

 

parameter.PNG

 

 

i want to use that value in if condition to filter an another table in power query:

if cond.PNG

 

But Parameter is not taking the value from list query. How to achieve it dynamically? Please assist..

 

1 ACCEPTED SOLUTION

Accepted Solutions
sk2019 Regular Visitor
Regular Visitor

Re: Filter table through list query

Hi  ,

 

Thank you for your inputs and assistance.

 

i also tried modifying query in M query without using Parameter and it worked fine.

i just put MonthListQuery (created table/list query) in M query to filter the table.

 

   #"Filtered Rows" = Table.SelectRows(#"Removed Other Columns", each [Month_End] = #"MonthListQuery"),

2 REPLIES 2
Community Support Team
Community Support Team

Re: Filter table through list query

Hi @sk2019 

Based on my research,it's not supported yet.You may vote for this similar idea.For further,please check if this article could help.

https://community.powerbi.com/t5/Desktop/How-to-dynamically-set-the-Parameter-Current-Value/td-p/891...

Regards,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
sk2019 Regular Visitor
Regular Visitor

Re: Filter table through list query

Hi  ,

 

Thank you for your inputs and assistance.

 

i also tried modifying query in M query without using Parameter and it worked fine.

i just put MonthListQuery (created table/list query) in M query to filter the table.

 

   #"Filtered Rows" = Table.SelectRows(#"Removed Other Columns", each [Month_End] = #"MonthListQuery"),