Filtering with parameters
Parameters are a key functionality when it comes to the definition of dynamic filtering logic. You can create parameters that will be used to filter and load data according to predefined values. This way, you will be able to work on a subset of data optimizing general queries' performance.
In this recipe, you will see how to create a parameter over a key value, for example, a product key.
Getting ready
For this recipe, you need to download the FactInternetSales
CSV file.
In this example, we will refer to the C:\Data
folder.
How to do it…
Once you open your Power BI Desktop application, you are ready to perform the following steps: