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…

Conditional formatting of data labels

Data labels in charts are always useful because they implicitly show us the value of the series, without the need to look at the axis. However, in traditional charts, they are always formatted the same way; they are displayed in the same font size and style, the same color… Power BI Desktop recently got the option of conditional formatting of these values, which makes the reports much more vivid.

Error Bars at Power BI reports

When we create predictions or analyze existing results, there is always the possibility of error. For this purpose, when displaying charts in Excel we have always been able to display error bars. Since recently, this option also exists in Power BI Desktop. In the “recipe” that follows, you will learn how to add and modify error bars on a column or bar chart.

CONVERT function

How many grams are there in one cup? How many grams fit in a tablespoon? And in a coffee spoon? This is information that until now you had to search for on the Internet, and since recently there is an Excel function that enables these and some other conversions. It is very easy to use, and if you want to know how, read this “recipe” (it cannot be converted into several smaller ones, but it is interesting)!