Changes made in August 2017 to Power BI Desktop
Part six of an eight-part series of blogs

A quiet month, after the frenetic activity of the July update, sees lots of small changes to matrices, tables and charts, but no single big update.

  1. Updates to Power BI Desktop for August 2017
  2. Parameters for What-If Analysis
  3. Live Connection to Power BI Service Data Sources
  4. Multiple Values for a Matrix can now Appear as Row Headers
  5. Conditional Formatting of Font Colour
  6. Customising Matrix Subtotals (this blog)
  7. More Improvement to Line Charts
  8. New Scatter Chart Insights

For a cumulative list of all of the updates to Power BI Desktop in the last few months, see this blog.  Our two-day Power BI Desktop course always uses the latest version of the software.

Posted by Andy Brown on 14 August 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.

Customising Matrix Subtotals

This small change lets you position and display subtotals more exactly, but to reproduce it you first have to have a matrix containing them.

Creating an Example Matrix

Suppose you create a matrix like this, which displays total sales by environment and family for a company selling toys:

Two row titles

Although there are two row titles, only one will display by default.

 

To display the second row title, click on the symbol shown below:

Expanding hierarchy levels

Click as shown to show both row titles together.

 

The resulting matrix shows subtotals by default:

Matrix with subtotals

You can now see subtotals!

 

Changing the Display of Subtotals

Now we've got some subtotals, you can change how they display:

Subtotal position

You can choose to display subtotals at the bottom of each section (the default) or the top.

 

Subtotals at the top show up alongside the row title:

Subtotals at the top

You can see the total sales for each environment next to the name.

 

You can also choose for which fields to display subtotals:

Per row level

Set the Per row level property to choose for which fields to display subtotals (here for both the EnvironmentName and the FamilyName fields).  For a matrix with only two row or two column fields, you won't see much difference.

 

You can do a similar thing to column subtotals - the only difference is that the property above is called Per column level, not Per row level.

This blog has 0 threads Add post