The main new features in the March 2017 update of Power BI Desktop
Part two of a four-part series of blogs

This is a small update, although the new matrix tool which is currently in preview mode will be a big change.

  1. Power BI Desktop - March Update
  2. New matrix visiualisation in preview (this blog)
  3. Colours Allowed in Text Boxes
  4. Percent-of-Total Labels in Pie and Donut Charts

You can see a list of all updates going back to November 2016 here.

Posted by Andy Brown on 24 March 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.

New matrix visiualisation in preview

I don't normally include preview features for this blog series, but the new matrix is too important not to mention:

Matrix preview

Once you've enabled it, this is what the preview tool looks like.

 

Having had a play with it, it looks just the same as the old matrix, but it will have a few extra features.  For example, you'll be able to go to the next level of a hierarchy:

Drilling down

You'll be able to drill down, as you can for charts.

 

Even better, you'll be able to right-click to drill up or down on a particular row or column:

Drill down on a row

This is a neat, simple implementation.

 

Also, you'll be able to change the indentation level for stepped layout of matrix row headers:

Stepped layout

The stepped layout indentation setting.

 

The above setting would give a new matrix like this:

Stepped matrix

The regions are indented in by 10 (whatever the unit is!).

 

Perhaps best of all, you will be able to click on a single figure to see the effect on other visualisations:

Drill down one cell

To see what the make-up of this figure 266 is, click on it!

I've used the future tense throughout, but if you enable this preview tool you'll be able to use it now.

This blog has 0 threads Add post