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