Forum Discussion

jppuam's avatar
jppuam
Helper V
5 years ago
Solved

alternate between 2 Bookmarks

Hello,

i've a slicer that filters information from my departments. And i want to show 2 different bookmarks that shows 2 charts in a specific area on a report

Can we do this based on a flag or other field ?

 

thanks,

JR

 

 

 

 

 

Need Help
  • v-robertq-msft's avatar
    v-robertq-msft
    5 years ago

    Hi, jppuam 

    According to your description, I can roughly understand your requirement, I think it’s achievable using a slicer and a button, you can try my steps:

    1. Create a slicer table:

     

    1. Create a slicer and a button and set the button like this:

     

     

    And you can get what you want, like this:

     

    This is the document I followed:

    https://debug.to/944/power-bi-select-bookmark-based-on-slicer

     

    You can download my test pbix file below

    Thank you very much!

     

    Best Regards,

    Community Support Team _Robert Qin

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

5 Replies

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee
    5 years ago

    Not totally clear on your scenario, but you can use a SWITCH measure with a disconnected table (or a calculation group) to change which measure is displayed in your chart(s), based on slicer selection(s).  Or you could make two buttons on top of each other and bookmarks that only display one at a time to toggle back and forth.

     

    Pat

     

    • jppuam's avatar
      jppuam
      Helper V
      5 years ago

      thansk mahoneypat,

      i dont quite understand.

       

      here an example of what i was trying to do.

       

      i've a slicer, and i want to show the bookmark 1 or 2 depending of a field that i've configurated for the departments.

      so for ex: i could have departments 1 and 2 showing the bookmark 1, and having the department 3 showing the bookmark 2.

      Is this possible ?

      thanks,

      JR

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee
    5 years ago

    Thanks for the clarification.  You can make 3 buttons (one for each department) and point them to the bookmarks.  I'm not aware of a way to go to a bookmark from a slice selection.

     

    Pat

     

    • jppuam's avatar
      jppuam
      Helper V
      5 years ago

      the problem is that the number of departments could change. so it has to work dinamically, thanks

  • v-robertq-msft's avatar
    v-robertq-msft
    Community Support
    5 years ago

    Hi, jppuam 

    According to your description, I can roughly understand your requirement, I think it’s achievable using a slicer and a button, you can try my steps:

    1. Create a slicer table:

     

    1. Create a slicer and a button and set the button like this:

     

     

    And you can get what you want, like this:

     

    This is the document I followed:

    https://debug.to/944/power-bi-select-bookmark-based-on-slicer

     

    You can download my test pbix file below

    Thank you very much!

     

    Best Regards,

    Community Support Team _Robert Qin

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.