WiseOwl Training - Established 1992
We're excited to announce that from 14th April we'll be running live online training courses too!
From 14th April we'll be running live online training courses too!
This page has 0 threads   |  Add post
Five star reviews Outstanding course feedback
Average score 9.33 out of 10, based on 9087 reviews
If you found this blog useful and you’d like to say thanks you can click here to make a contribution. Thanks for looking at our blogs!

BLOGS BY TOPIC

BLOGS BY AUTHOR

BLOGS BY YEAR

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.

  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)
This blog has 0 threads Add post