Drillthrough reports

Drillthrough is an option that allows one or more reports, extracted on a separate report page, to be obtained based on the chosen dimension according to which we want to display its details. In this way, PowerBI reports get on interactivity, and by using this feature one complex report can be divided into several smaller and simpler ones, making it easier to find the information requested.

Buttons

Appearance of the report is no longer only important thing, but also its interactivity. Therefore, new feature – buttons are added to PowerBI. These are graphic objects intended to give you a step backward, if you drilldown within the report, to launch a report that is recorded as a Bookmark or display a table/chart that was created as a result of a pre-designed question.

Filtering by lists

Slicers are great feature, but unfortunately they can not be used to filter traditional Excel reports. If we use the conditional aggregation functions, in order to calculate the desired values, as well as the data validation technique, we can make simple but effective filters by selecting the values from the list. By selecting the criteria from the list, the automatic update of the values in the report is performed. Let’s see how this works!

Parallel periods

The Power Pivot add-in allows you to make different calculations depending on the time period in which the sales occurred, by writing formulas in DAX language. To use these features you need to have one of the latest versions of Microsoft Office Pro Plus. Since many do not have this feature, it remains only to deal with the traditional lookup functions about which application I’ll write in following „recipe“.

C/S ratio

How good are the sales results? There are many indicators that can be used to control sales, and one of them is a C/S ratio. It represents the relationship between the contribution (aka difference in price, earnings, margin) and the amount of sales. By monitoring this indicator we can track change of earnings through time and that can show us how well a trade margin is formed.