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 (this blog)
- Drill-through navigation buttons
- Multi-column sorting
- Searching in the filter pane
- Line charts can now have a dual axis
- 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.
Page navigation buttons
You've been able to navigate between pages for a while using bookmarks:
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:
We'll add a button to go to the first page.
To do this, first choose to insert 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:
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:
|
|
| 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:
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.
- The March 2020 Power BI Desktop Update
- The new ribbon is live (sort of)
- Page navigation buttons (this blog)
- Drill-through navigation buttons
- Multi-column sorting
- Searching in the filter pane
- Line charts can now have a dual axis
- The new DAX COALESCE function
- Changes to ArcGIS
- Query Diagnostics
- Generating embed codes is now turned off by default