Changes made in August 2017 to Power BI Desktop
Part four 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 (this blog)
  5. Conditional Formatting of Font Colour
  6. Customising Matrix Subtotals
  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.

Multiple Values for a Matrix can now Appear as Row Headers

Up to this version, when you have a matrix with multiple values like this:

Multiple values

This matrix has two values to display.

 

Power BI Desktop would display these as column headers automatically:

Column headers for matrix

The value field names appear at the top of each column.

Now in the Values section of the formatting toolbar, you can change this:

Show on rows

Set the Show on rows property to On to display values as row titles, not column titles.

 

Here's what the results would look like:

Show on rows enabled

If you show multiple matrix values on rows, this is what you get.

 

Remember the general rule for Power BI Desktop Updates - the longer the title, the less important the change! 

This blog has 0 threads Add post