WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
30 years in business
Wise Owl Training
30 years in business
See 516 reviews for our classroom and online training
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)

For a cumulative list of all of the updates to Power BI Desktop since November 2016 see this blog, or have a look at the Power BI courses that we run.

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