WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
30 years in business
Wise Owl Training
30 years in business
See 525 reviews for our classroom and online training
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