Microsoft Power BI Cookbook

Multi-parameter query filters

In this example, the goal is to filter the fact table by both a time frame (start and end dates) as well as a dimension:

1. From a Power BI Desktop file, open the Query Editor and click on New Parameter from the Manage Parameters dropdown.
2. Create a parameter for the Sales Territory Group with a text data type:

3. Name the parameter Territory Group and enter the names (North America, Europe, or Pacific) as Suggested Values.

4. Create a new query (from a blank query) that selects the unique key values associated with this dimension:

let ParamFilter = Table.SelectRows(#"Sales Territory", each [Sales Territory Group] ...