We're excited to announce that from 14th April we'll be running live online training courses too!
From 14th April we'll be running live online training courses too!
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