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 OK the page changes to a page OK, if the client is not ok change to page Not ok.

Without use button or bookmarks 

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

5 Replies

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