Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Change pages PB desktop

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 O...
Need Help
  • Anand24's avatar
    Anand24
    6 years ago

    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's avatar
Anand24
Icon for Super User rankSuper User
6 years ago

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's avatar
    Anonymous
    Not applicable
    6 years ago

    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's avatar
      Anand24
      Icon for Super User rankSuper User
      6 years ago

      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 !!!

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

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