COVID-19: Choose between our familiar (but now socially distanced) classroom training courses and our excellent new live online courses.
Changes for the June 2020 update of Power BI Desktop
Part four of a six-part series of blogs

This month's update doesn't include many changes - the biggest being probably the emergence of the hierarchical slicer from preview.

  1. Power BI June 2020 update - summary of new features
  2. Hierarchical slicers
  3. Much-improved mobile report designer
  4. Individual dots on line charts (this blog)
  5. Automatic refresh
  6. AI insights in Query Editor

We've been creating our idiosyncratic monthly blogs on Power BI updates since November 2016, and also deliver online and classroom Power BI courses.

Posted by Andy Brown on 28 June 2020

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.

Individual dots on line charts

This is quite a niche change, but for some reason I really like it!

Individual points coloured

Here I've used red dots to show the two places where sales peak.

 

To set individual colours for a line chart, set the Show all property in the Data colors formatting card:

Data colors - show all

After setting this property, you'll be able to set individual colours for markers.

 

You can then set colours for each point:

Setting individual colours

Here I've chosen to colour the 2017 point in bright red.

 

And that's pretty much it for this new feature!

Microsoft say: "Note that in this release, this feature will show dots for your categories across all of your series. In the coming releases, we plan to extend this feature to allow for more control over choosing particular series."  If you only have one series for your line chart, as above, this won't concern you.

This blog has 0 threads Add post