COVID-19: Choose between our familiar (but now socially distanced) classroom training courses and our excellent new live online courses.
What's new in the May 2020 Power BI update
Part five of a six-part series of blogs

The May 2020 update is a good one! The decomposition tree is a seriously good new visual, drop shadows are a nice idea well-implemented, and there are lots of improvements to the way buttons look and work.

  1. New features introduced in the May 2020 Power BI Update
  2. Visuals can now have drop shadows
  3. Buttons can have fill images
  4. The new Decomposition Tree visual
  5. Improvements to page navigation buttons (this blog)
  6. The drill-through action is out of preview, and enhanced

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 24 May 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.

Improvements to page navigation buttons

In March Microsoft introduced the ability to navigate to specific pages in Power BI, and I blogged about it then:

Page navigation button

The basic principle: you can create a button allowing a user to go to a specific page.

Note that you can now attach page navigation buttons to shapes, as shown for the example above (this is a new feature introduced this month).

Notwithstanding the small improvement explained above, the big change is that you can now create a page navigation dropdown.  The rest of this page explains how to do this!

Creating a table of pages

To start with, choose to create a table of pages:

Enter data button

One way to do this would be to click on the Enter data icon and type them in, although it would be better to store them in a separate Excel workbook, CSV file or database table and load them.

Create a table giving the names of your pages:

Page names table

Make sure that your page names correspond exactly with the page tabs.

Here are the 3 pages I want my user to be able to navigate between:

The page tabs

The pages in my report.

Creating a slicer for the page choice

Create a dropdown slicer based upon this new table:

Dropdown slicer

Your slicer doesn't have to be dropdown, but if it is it will take up less room on the page.

After hiding the slicer header and making my slicer single-select, this is what we're left with:

Single dropdown slicer

Now we just need to make this go to the correct page!

 

Creating a page navigation button

Now create a separate button allowing you to go to a particular page:

Choose to insert a button

Choose to insert a button, and add text or an image to it.

Format this:

Formatted button

Make it clear what your button will do.

Now assign an action to your button, and make sure it works:

Action to go to page

Here clicking on my button should take me to the first page. Remember that when you're testing this you'll need to hold down the Ctrl key when you click on your button (you won't have to do this when you've published your report).

 

Making the page choice dynamic

Time now to make the page you go to be the one you've chosen in your slicer.  Go back to your action choices for your button, and click on the fx symbol:

Button conditional destination

We're going to make the page you jump to dynamic.

 

Choose to go to the value of the page field chosen in your slicer:

Choose the page name field

Choose the page name field from your new Pages table.  For the statistic, it doesn't matter whether you choose First or Last, since you will only ever have one value selected at a time.

 

Testing your system

Before testing my system, I've set the button tooltip to show the page name too:

Button tooltip

I've set both my button action destination and the button action tooltip to the page name field value.

 

And now it should work!

The final system

You can now choose which page to go to!

You could if you like synchronise your slicer to go on every page, but you'd have to copy the button manually onto each page, since you can't sync any types of visuals other than slicers.  Well, not yet, anyway ...

This blog has 0 threads Add post