Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 parameter. I tried to filter using [Dimension] = parameter in the M query, but that does not work for multi-valued parameter. If I choose List.Contains ({Parameter},[Dimension]) I also get an error message "We vouldn't fold the expression...". Any idea on the correct syntax for filtering the table?
Thanks
Solved! Go to Solution.
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/
Hi @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
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/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.