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!
Updates made in February 2017 to Power BI Desktop.
Part six of a six-part series of blogs

A summary of the most important changes for Power BI Desktop users in the February 2017 update.

  1. Power BI Desktop - February Update
  2. Word wrap within matrix row and column headers
  3. Changing the font size in chart axes
  4. Setting a minimum category width for some charts
  5. Controlling the width of lines in line charts
  6. Showing percentages as quick calculations (this blog)

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

Posted by Andy Brown on 16 February 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.

Showing percentages as quick calculations

Power BI Desktop has two new ways to show calculations, both very welcome:

Quick Calc

You could already choose to show a quick calculation for any value in a table or matrix.

 

The two new ways are to show percentages of row and column totals:

Percentage of column total

This method would show figures as a percentage of each column total.

 

Here's what this would show for a typical matrix:

Final matrix

The totals at the bottom obviously show 100%.

It seems that Microsoft are gradually adding in all of the pivot table calculated field options ...

This blog has 0 threads Add post