Thursday, April 27, 2023

Power BI Filter Table using a CSV Parameter

In Power BI you can filter a table using multiple values using the Text.Split and List.Contains Power Query functions.

Step 1.  Create a Parameter in Power BI and add the values separated by a comma (,)

Example: CSVList with value 1,2,3,4

Power Query - Filter table using CSV Parameter


Step 2: Add a filter to your table using the "Text.Split" and "List.Contains" Power Query function