COVID-19: Choose between our familiar (but now socially distanced) classroom training courses and our excellent new live online courses.
The March 2020 update to Power BI desktop is a full one, as this blog shows!
Part seven of a eleven-part series of blogs

New goodies in this month's update include the roll-out (sort of) of the new ribbon, new actions for buttons, multi-column sorting and a second axis for line charts.

  1. The March 2020 Power BI Desktop Update
  2. The new ribbon is live (sort of)
  3. Page navigation buttons
  4. Drill-through navigation buttons
  5. Multi-column sorting
  6. Searching in the filter pane
  7. Line charts can now have a dual axis (this blog)
  8. The new DAX COALESCE function
  9. Changes to ArcGIS
  10. Query Diagnostics
  11. Generating embed codes is now turned off by default

For a cumulative list of all of the updates to Power BI Desktop in the last few years see this blog, or have a look at the Power BI courses that we run.

Posted by Andy Brown on 14 March 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.

Line charts can now have a dual axis

A familiar problem - you want to display two different things on the same line chart:

Two lines on a chart

In this chart the total quantity swamps the average price, and so the blue line becomes meaningless.

You can now use a second axis for a line chart:

Moving a measure

Here I'm moving the Average of Price field to the Y2 card in the field well.

 

By default Power BI uses the same formatting for both lines:

Second axis

The average price is now charted against a second axis.

However, you can have different formatting for each axis:

Y2 axis

You can expand the Y2 axis card to change its formatting.

 

The full range of formatting options is available for each axis:

Formatting the Y2 axis

The second axis can have its own title, scale and formatting.

 

A very welcome change!

This blog has 0 threads Add post