A summary of the changes for the September 2017 update to Power BI Desktop
Part four of a six-part series of blogs

The September 2017 Power BI Desktop update introduces ribbon charts, a feature to explain the increase or decrease for any chart point and a drill-through feature allowing you to temporarily switch to a summary page.

  1. What's New in Power BI Desktop - September 2017 Update
  2. Drill-through to a Summary Report Page
  3. Ribbon Charts
  4. Automatically explaining the increase or decrease (this blog)
  5. Showing Keyboard Short-Cuts
  6. Preview Features

For a cumulative list of all of the updates to Power BI Desktop in the last few months, see this blog.  Our two-day Power BI Desktop course always uses the latest version of the software.

Posted by Andy Brown on 12 September 2017

You need a minimum screen resolution of about 700 pixels width to see our blogs. 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.

Automatically explaining the increase or decrease

It seems a shame to waste the ribbon chart I created for the previous part of this blog, so let's use this to show how this new feature works:

Explain the increase

I can see that sales for the North region shot up in 2015, but why? And how?

If you right-click and choose the preview option shown above, you may find out:

Waterfall chart

Power BI Desktop creates a waterfall chart showing the make-up of the difference, with a text description.

Note that you can change the chart type by clicking on the icons at the bottom:

Regression chart

Here I've gone for a regression chart, by clicking on the appropriate icon at the bottom.

 

This is a pretty impressive feature (which obviously isn't limited to ribbon charts!).  Note, however, that it is still in preview mode (as the footnote at the bottom of the analysis shows).

This blog has 0 threads Add post