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…

Sales volume in relation to the goal

Sales volume in relation to a given target can be shown by a goal achievement chart. There is another way to do this, and that is to display real sales values ​​instead of moving the intersections of the x and y axes, using a Combo chart in which the target would be a horizontal line based on the data in the table. Also, by adding the Spin Button control, we will be able to change a goal easily, which leads to the dynamic chart.