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:
  1. Name the parameter Territory Group and enter the names (North America, Europe, or Pacific) as Suggested Values.
  1. 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] ...

Get Microsoft Power BI Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.