Changes made in August 2017 to Power BI Desktop
Part seven 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 (this blog)
  8. 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:

Line chart styles

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

Line styles

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:

Legend style

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:

Line only legend

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:

Circle default icon

Here we've turned the default circle icon off.

 

Without a circle icon, the legend appears as a solid line:

Legend as 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!

This blog has 0 threads Add post