Browse 531 attributed reviews, viewable separately for our classroom and online training
Power BI November 2021 Update
Part three of a six-part series of blogs

This month's update is a biggie, with the introduction of a page navigator and a bookmark navigator, but it's the new formatting pane waiting in preview which will really changes people's lives.

  1. Power BI November 2021 Update
  2. Preview features: new formatting pane and scorecard visual
  3. Create a page navigator (this blog)
  4. Bookmark navigators
  5. Two small improvements to charts
  6. Text boxes support bullet points and superscript/subscript

We've been creating our idiosyncratic monthly blogs on Power BI updates since November 2016, and also deliver online and classroom Power BI courses.

Posted by Andy Brown on 23 November 2021

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.

Create a page navigator

A page navigator allows you to move between pages easily:

Page navigator

The page navigator allows you to go to a page easily (although in design view you will have to hold down the Ctrl key to click on a button).

 

A page navigator will automatically show the correct list of pages and selected page, but it doesn't appear to have the sync facility that slicers enjoy (so you have to add a different page navigator on every page of your report). 

Creating a page navigator

So let's suppose you have a report containing the following pages:

Report pages

Note that the last page is hidden, being only used for drill-down.

You can now create a page navigator allowing your users to choose which page they want to view:

Page navigator

Creating a page navigator (I'll cover bookmark navigators separately later in this blog).

 

Here's what this looks like originally:

Initial page navigator

I've put this on my Menu page, which is why this is shown selected.

If you think this looks like a horizontal slicer ... me too!  I would imagine Microsoft have used the same code, and created an internal table containing the pages in your report.

Choosing which pages to show

You can choose whether hidden and tooltip pages appear in the navigator:

Hiding hidden pages

Choosing this option will mean that the For drill-down page above disappears from the navigator menu.

 

Changing the layout

You can have horizontal, vertical or grid navigators:

Changing the layout

The layout options for a page navigator.

 

For example, I could choose these settings:

Grid layout

I've chosen a 2 x 2 grid, with increased padding between the menu items.

 

Here's what this will look like:

Grid in appearance

The grid will (as requested) have 2 rows and 2 columns.

 

Formatting your page navigator

Because a page navigator is made up of shapes, you have a wide range of formatting options:

Shape formatting

You can choose which shape each menu item should be, and how it should appear.

 

Here's what the option shown above would show:

Bigger snips

Rounded octagons with big snips!

 

Formatting the selected page

Power BI will automatically show the current page differently.  How differently is up to you:

Selected page

When formatting your navigator, you can choose to show the selected page fill and outline colours differently.

 

Here's what the options above would show:

Selected button formatted

The selected button appears in pink.

 

All in all, a very nice and well-implemented feature, which to some extent renders the app workspace page navigation bar redundant.

This blog has 0 threads Add post