Slicers are interactive objects that allow you to filter visuals, individual pages, or entire Power BI reports. Since recently it is possible to place them in a hierarchical order, which is really convenient and makes it easier for us to review the filtering criteria. The procedure for placing slicers in this order is very simple, and you will find out how it is done in the text that follows …
Buttons in Power BI reports are used to navigate between different pages of the report, so in addition to the functional aspect, it is important that they look nice. When you add a blank button, Power BI Desktop provides many options for formatting its appearance. Since recently it is possible to add images that will represent a button, and also to select different images for different states (default, mouse over, click etc.)
Power BI Desktop has been supporting buttons for some time which make it easy to navigate between multiple pages within a Power BI report. Until now, the button could only lead to one given destination (page) and now, by combining the button and the slicer, it is possible to provide a selection of the page with the report you want to look where you further go by clicking on the button. In this way slicers become main tool for navigation.
Many years ago I worked for ECOFINANCE company where, at my time, I wrote an Excel invoicing application. It seems to me that it was quite easy to use. Partly because it was enough to enter part of the name of the code or product to find the desired item. The seller would then only select the quantity and packaging and could quickly continue to enter items until the document is completed. Today this can be achieved much easier, without any VBA programming …
In your day-to-day work, many of you copy data from a company’s business information system or some spreadsheet where they are exported to create the necessary reports. The problem arises when the data changes. How to trace where the change occurred? What is the difference between a source and a derived table? In the text that follows, you will see how to use the INDEX and MATCH functions, as well as the conditional formatting technique, to highlight the differences between the tables.