Changes made in August 2017 to Power BI Desktop
Part eight 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
  7. More Improvement to Line Charts
  8. New Scatter Chart Insights (this blog)

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.

New Scatter Chart Insights

Suppose that you have the following scatter chart:

Scatter chart

This chart compares the average size of a shopping centre against the average number of units.

Merry Hill (a shopping centre near Birmingham, for foreign readers), for example, has a size which constitutes 1.32% of the national UK average, but the number of shopping units only comprises 1.03% of the national UK average.  It therefore lies above the ratio line shown.

To display the symmetry shading and ratio line above, first choose Analytics:

Analytics tool

With the scatter chart selected, click on this tool.

 

You can now display and configure the shading and line required:

The colour shading and ratio line

Here we've added symmetry shading using the default colours, and a ratio line.

 

Sometimes the ratio line won't follow the division between the symmetry colours, but I confess that at this point my interest in scatter charts fell away.  If yours hasn't, try the Microsoft example here.

This blog has 0 threads Add post