If we then cross-filter the tree by Nintendo, Xbox sales are blank as there are no Nintendo games developed for Xbox. When we cross-filter the tree by Ubisoft, the path updates to show Xbox sales moving from first to second place, surpassed by PlayStation. To show a different scenario, the example below looks at video game sales by publisher. The order of the nodes within levels could change as a result. Interacting with other visuals cross-filters the decomposition tree. Selecting a node from an earlier level changes the path. Selecting a node from the last level cross-filters the data. This process can be repeated by choosing another node to drill into. Selecting Forecast bias results in the tree expanding and breaking down the measure by the values in the column. Selecting the + lets you choose which field you would like to drill into (you can drill into fields in any order that you want). Notice that a plus sign appears next to your root node. Add these fields to the Explain by bucket. The next step is to bring in one or more dimensions you would like to drill down into. In the example below, we're visualizing the average % of products on backorder (5.07%). Once you drag your measure into the field well, the visual updates to showcase the aggregated measure. Explain By – one or more dimensions you would like to drill down into.

Analyze – the metric you would like to analyze.

The visualization requires two types of input:

Select the decomposition tree icon from the Visualizations pane. Sharing your report with a Power BI colleague requires that you both have individual Power BI Pro licenses or that the report is saved in Premium capacity.

The first tree video game download