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 three 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 (this blog)
  4. Drill-through navigation buttons
  5. Multi-column sorting
  6. Searching in the filter pane
  7. Line charts can now have a dual axis
  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.

Page navigation buttons

You've been able to navigate between pages for a while using bookmarks:

Page arrows

You can achieve effects like this by creating a bookmark for each page, and then assigning actions to the arrow buttons to take you to each bookmark.

 

However, this was time-consuming, and also cluttered your report up with bookmarks.  There's now a new action to go to a page, which I'll show using this example:

Page for button

We'll add a button to go to the first page.

To do this, first choose to insert a button: 

Adding a button

You can add a button of any type you want, then format it and assign an action. Here I've chosen a blank button to start with.

 

Format your button:

Formatted button

There's so much more you can do with button formatting than this, but time is of the essence ...

 

In the button's Action card, choose which page you want to go to:

Page navigation Choosing page to go to
Choose Page navigation ... ... then choose a page.

Don't forget that when testing your button you'll need to hold down the Ctrl key when you click on it:

Clickable button

Clicking on the button should take you to the page you requested.

 

A really nice, simple implementation of a sensible feature, which will make it much easier to navigate between pages.

This blog has 0 threads Add post