Whether we use Excel BI or Power BI data model, we can create a hierarchy of employees manually or with the help of some DAX functions. In this text you will learn how to use two such functions: PATH and PATHITEM. With their help, it is possible to create calculated columns that show the hierarchical level of each of the employees within the company.
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 …
Recent versions of Power Pivot possess the feature that automatically generates hierarchies and columns that calculate year, quarter, and month for date columns. It is automatically activated when you drag such column into a Power Pivot report. This can be of use, but it can also bother you. In the following text you will find out how you can turn on or off this Excel feature.
Treemap is a new chart that comes with Excel 2016, and is used for hierarchical value display in a decreasing order. The values are represented by rectangles, where the largest rectangle represents the largest value, and to the right of it are a smaller rectangles with lower values. This type of chart is convenient to track in the city we have the best turnover, or which item brings the highest revenue …
When we use Power Pivot reports often happens that we’ll use two or more reporting dimensions, hierarchically arranged, to provide organized access to information. If something like this occurs frequently we can use specific functionality of Power Pivot reports: Hierarchy. Hierarchy is a named set of hierarchically arranged reporting dimensions, and more about ways for creating and using them you’ll find out if you read this recipe.