A barcode is a way of representing data in a form that is readable by machines. There are several different standards that are used to create barcodes, and the most common is the one that contains thirteen digits; i.e. twelve + one control digit, which is calculated using an algorithm. Also, there are several different types of barcode readers. In this text, you will find out how you can use a barcode to mark products…
How to replace zeros with empty cells? Although this question seems simple, you may find yourself in a situation where you need something like this, and you will not have the right answer. When it comes to data in Pivot tables, it is logical to define this in the options. But they allow you to determine how to treat empty values, not zeros. Zero is not an empty value. You will find out how to replace zeros, regardless of the type of table, in the “recipe” that follows…
Dataflows are a feature within Power BI which is used to connect and transform data to utilize them as datasets when designing reports. It is a good way to create reusable datasets that are refreshed each time when a change occurs. They can be used by different users within a company to create reports not only in Power BI, but also in other Power Platform services.
Metrics is a functionality that allows you to monitor various indicators within the Power BI service: goals, tasks, ratio numbers, KPIs… Planned and realized metrics can be entered manually, retrieved from reports or linked to some other indicator. Also, data on planned and realized metrics can be pulled down to Power BI Desktop using the new slicer, which enables easier monitoring and coordination between management, executors and report designers.
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…