Power BI | Decomposition tree exercise | Create a new Power BI report showing a decomposition tree

This exercise is provided to allow potential course delegates to choose the correct Wise Owl Microsoft training course, and may not be reproduced in whole or in part in any format without the prior written consent of Wise Owl.

Software ==> Power BI  (111 exercises)
Version ==> Latest update
Topic ==> Decomposition tree  (1 exercise)
Level ==> Average difficulty
Subject ==> Power BI training
Before you can do this exercise, you'll need to download and unzip this file (if you have any problems doing this, click here for help).

You need a minimum screen resolution of about 700 pixels width to see our exercises. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Create a new Power BI report, and load the CSV file from the above folder.  Use this to create a decomposition tree visual:

Decomposition tree

Here we are showing the average box office takings by director, genre and certificate.  Unlike almost any other visual, you won't initially see any grouping levels.


Expand the top node to show the average box office takings for 12A Comedy films directed by John Madden:

Expanding decomp tree

Note that you should also lock the certificate column to prevent anyone collapsing it.

Now see how many of the following tricks you can apply:

Formatting a decomp tree

See below for some ideas of things to do!

In the above visual we've made the following changes:

  1. When you click on a node, it should expand or collapse it automatically.
  2. Each data bar should show the amount relative to that shown in the total node (ie 644.31 million).

Save your report as Visually appealing, then close it down.

You can unzip this file to see the answers to this exercise, although please remember this is for your personal use only.
This page has 0 threads Add post