BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
This is a small update, although the new matrix tool which is currently in preview mode will be a big change.
- Power BI Desktop - March Update
- New matrix visiualisation in preview (this blog)
- Colours Allowed in Text Boxes
- 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:
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:
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:
This is a neat, simple implementation.
Also, you'll be able to change the indentation level for stepped layout of matrix row headers:
The stepped layout indentation setting.
The above setting would give a new matrix like this:
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:
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.