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 (this blog)
- 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.
More Improvement to Line Charts
You can now set lines in a line chart to either dotted, dashed or solid:
An example of each of the 3 types of line style.
You can also control how the legend for lines charts appears.
However, this update seems to have removed the option to set line markers completely, as this forum agrees. I'm sure this will be fixed by an update very soon ...
Changing Line Styles
To do this, use the Shapes section of the Formatting toolbar
You can set the line style for all lines in your chart, or (as here) toggle the Customize series option, then use the drop arrow to set different lines styles for different data series.
Changing Legend Appearance
You can (as mentioned) also control how line charts show legends:
You can set the legend style to show just markers, just lines (as here) or both lines and markers.
For this choice (Line only), here's what you'd see for the above chart:
The legend displays just the line segment.
If you choose to show the legend as just a marker, you can either display this as a circle (the default) or as a line:
Here we've turned the default circle icon off.
Without a circle icon, the legend appears as a solid line:
The legend using a solid line.
The Match line color property above determines whether the legend colour matches the colour of the line (On) or marker (Off). As I mentioned at the top of this blog, this feature is a bit academic, as the option to set line markers seems to have been temporarily removed!
- 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 (this blog)
- New Scatter Chart Insights