![]() ![]() ![]() High Value: Considers all available fields and determines which one to drill into to get the highest value of the measure being analyzed.Using the supply chain sample again, the default behavior is as follows: The analysis can work in two ways depending on your preferences. The splits are there to help you find high and low values in the data, automatically. These splits appear at the top of the list and are marked with a light bulb. You can use “AI Splits” to figure out where you should look next in the data. Selecting the Nintendo node therefore automatically expands the tree to Game Genre. Xbox, along with its subsequent path, gets filtered out of the view.ĭespite the path disappearing, the existing levels (in this case Game Genre) remain pinned on the tree. 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. ![]()
0 Comments
Leave a Reply. |