Please note javascript is required for full website functionality.


Power BI Blog: Even More on the Decomposition Tree Visualisation

8 April 2021

Welcome back to this week’s edition of the Power BI blog series. This week, Jonathan Liau will continue his look at the Decomposition Tree visualisation.

Last week we continued creating our simple decomposition tree:

The Decomposition tree can also display negative numbers. This example contains a measure that compares the dollar sales amount of the selected year compared to the previous year. Called Year-Over-Year (YoY), this metric is often displayed as a percentage. However, in this example, we have used YoY # Sales to display an absolute value (i.e. a quantity, rather than a percentage).

If we plot this measure into the ‘Decomposition Tree’ visualisation, we can see that the visualisation will change to display negative numbers:

This is a good example where we can see that the Country field has a been adapted to show both positive and negative numbers. If we change the Year slicer to 2021, we will get the following results:

Each field will adapt accordingly based on the measure being analysed. We can also use the down arrow at the bottom of the City column to display the cities with less sales in 2021 compared to 2020.

Just another feature of the ‘Decomposition Tree’ that allows to easily display granular year over year changes in sales data over a hierarchy of fields.

That’s it for this week! Highlighting how negative numbers are shown on the Decomposition Tree. Join us next week for more on Power BI.

In the meantime, please remember we offer training in Power BI which you can find out more about here. If you wish to catch up on past articles, you can find all of our past Power BI blogs here.