WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
30 years in business Wise Owl Training
30 years in business
See 519 reviews for our classroom and online training
This page has 0 threads   |  Add post
Five star reviews Outstanding course feedback
Average score 9.41/10, based on our 1,804 latest 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 since November 2016 see this blog, or have a look at the Power BI courses that we run.

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