Report parameters

Report parameters are a new Power BI Desktop feature that allows you to create dynamic slicers with which you can influence the appearance of the report. In the previous “recipe”, you could see how it looks when we create field parameters, and now you will find out how to make those that contain numerical values. We will create a parameter that describes the sales target, then we will change it and see how it affects the chart…

Dynamic slicers

Slicers are visuals, graphic objects that enable filtering of pages or entire reports. They usually have fixed values. By introducing Power BI report parameters, when parameterizing according to fields, it is possible to set dynamic slicers which we can use to display visuals with different content. For example we can choose whether should track sales by manufacturer, brand, classification or sales group…

Power Query parameters

Parameters are variables or sets of values ​​that are intended to influence the appearance of a query. They are mostly used for filtering, but if you know the “M” language you can also use them for other purposes. Since I will not (for now) write about how “M” statements are created, I will use a simple example where a single parameter will be created and we will use it to filter a query.