BLOGS BY TOPIC▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
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.
- The March 2020 Power BI Desktop Update
- The new ribbon is live (sort of)
- Page navigation buttons
- Drill-through navigation buttons
- Multi-column sorting
- Searching in the filter pane
- Line charts can now have a dual axis (this blog)
- The new DAX COALESCE function
- Changes to ArcGIS
- Query Diagnostics
- 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:

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:

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:

The average price is now charted against a second axis.
However, you can have different formatting for each axis:

You can expand the Y2 axis card to change its formatting.
The full range of formatting options is available for each axis:

The second axis can have its own title, scale and formatting.
A very welcome change!
- The March 2020 Power BI Desktop Update
- The new ribbon is live (sort of)
- Page navigation buttons
- Drill-through navigation buttons
- Multi-column sorting
- Searching in the filter pane
- Line charts can now have a dual axis (this blog)
- The new DAX COALESCE function
- Changes to ArcGIS
- Query Diagnostics
- Generating embed codes is now turned off by default