BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
A summary of the most important changes for Power BI Desktop users in the February 2017 update.
- Power BI Desktop - February Update
- Word wrap within matrix row and column headers
- Changing the font size in chart axes
- Setting a minimum category width for some charts
- Controlling the width of lines in line charts
- 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:
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:
This method would show figures as a percentage of each column total.
Here's what this would show for a typical 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 ...