Change pages PB desktop

[Anonymous]

There is a way to change between pages if a selectedvalue is set ?

I have a list of clients and they have a status ( OK, not OK, almost ok) for instance, if the slicer is selected with a client OK the page changes to a page OK, if the client is not ok change to page Not ok.

Without use button or bookmarks 

[Anand24]

Hi @Anonymous ,

Here are the steps you can follow:

1. Create a table with your page names; Column from this table will be used in slicer

2. Create a button; After slicer selection, clicking on this button will navigate user to slicer selected page

3. Create a new measure below below dax:

PageNav = SELECTEDVALUE(TableName[ColumnName])

4. Click on the button(created in step 2) and its format tab and follow below clicks:

Enable Action -> Type = Page navigation -> Destination = fx and select measure(created in step 3) -> OK

Now select the page you want to navigate to as slicer selection and click on the button and you will navigate to desired page.

Reference Link: https://www.youtube.com/watch?v=pwBfCgRF4Fs

Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!

[Anonymous]

This solution work only with a button to pass the measure of the page rigth ?

There is a event or function to use when I pick a slicer option? For innstance, in the moment 9 on click in the slicer ) i go to the another page ! without a botton !!!!

[Anand24 · Accepted solution]

Hi @Anonymous ,

I'm not completely sure about this but as far as i know, there no such event/trigger that will navigate you to another page on slicer page selection.

Basically the trigger here is Page Navigation functionality or bookmark activation functionality and these don't simply work on slicer selections.

You can probably submit this as an idea so that Power BI can come up with such fucntionality in future.

Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!

[Anand24 · Accepted solution]

Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!

[Anonymous]

Unfortunately I came in this same conclusion....!!!

I miss some functionalities like i used to use in Delphi , several years ago. We had a lot o option under the objets in screem ( onclik, lostfocus, infocus, onselected, etc).

If we have this kind of option in PB somethings will be more simply.

But thansks for the return.....

[nandukrishnavs]

@Anonymous 

Refer to this:https://medium.com/@vivek.ranjan22/dynamic-page-navigation-in-power-bi-desktop-e97b9a11fd05

This will help.

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂