Forum Discussion
Solved
Dynamic query parameters multi-value
Hello I have a direct query facts table that I filter using single valued parameters for start and end date. That works fine, and I would like now to filter my table using a multi-valued paramete...
If Parameter is a list, then you don't want to wrap it in another set of {}. Maybe try just
List.Contains(Parameter, [Dimension])Reference: https://blog.crossjoin.co.uk/2021/10/10/multi-value-parameters-in-power-query-online/
v-jingzhang
Community Support
Community SupportHi fduperier
How do you want to apply the multi-valued parameter to query the fact table? Suppose you have multiple start dates and multiple end dates, data in which date periods should be brought into Power BI?
Best Regards,
Community Support Team _ Jing