BLOGS BY TOPIC▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
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.
- Updates to Power BI Desktop for August 2017
- Parameters for What-If Analysis
- Live Connection to Power BI Service Data Sources
- Multiple Values for a Matrix can now Appear as Row Headers
- Conditional Formatting of Font Colour
- Customising Matrix Subtotals
- More Improvement to Line Charts
- 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:

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:

With the scatter chart selected, click on this tool.
You can now display and configure the shading and line required:

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.
- Updates to Power BI Desktop for August 2017
- Parameters for What-If Analysis
- Live Connection to Power BI Service Data Sources
- Multiple Values for a Matrix can now Appear as Row Headers
- Conditional Formatting of Font Colour
- Customising Matrix Subtotals
- More Improvement to Line Charts
- New Scatter Chart Insights (this blog)