Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
AnandNamburi
Helper III
Helper III

Need to flip the bookmarks based on slicer selection

Hi All,

 

I have a report and in that report i'm having 4 visuals. In the same page I have a slicer and in that if I select "All" first 2 reports need to dipslay and if I select any other except "All" all the 4 reports need to dipslay.

 

For this I have created 2 bookmarks one with 2 reports & other with 4 reports. But here I'm in aconfused state that how can I map these bookmarks to my slicers. Can anyone help me here to acheive this.

 

Thanks,

Anand

2 ACCEPTED SOLUTIONS
amitchandak
Super User
Super User

@AnandNamburi , do you want to change the bookmark based on the slicer value?  I doubt that.

 

 

if needed, refer bookmark examples:https://www.youtube.com/watch?v=PTOJC42rg_k

https://radacad.com/clear-all-slicers-in-power-bi-a-bookmark-story

View solution in original post

v-alq-msft
Community Support
Community Support

Hi, @AnandNamburi 

 

It is unsupported to change the bookmark based on the slicer value. There is no 'Action' options for slicers. As a workaround, you may try going to specific bookmark based on buttons. The pbix file is attached in the end.

Table:

c1.png

 

Best Regards

Allan

 

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

View solution in original post

12 REPLIES 12
kayden
Frequent Visitor

Is there really no work around? OR are slicers to trigger measures better? But that would require DAX. And IMO DAX defeats the purpose of having powerBI in the first place (no code BI)

v-alq-msft
Community Support
Community Support

Hi, @AnandNamburi 

 

It is unsupported to change the bookmark based on the slicer value. There is no 'Action' options for slicers. As a workaround, you may try going to specific bookmark based on buttons. The pbix file is attached in the end.

Table:

c1.png

 

Best Regards

Allan

 

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

amitchandak
Super User
Super User

@AnandNamburi , do you want to change the bookmark based on the slicer value?  I doubt that.

 

 

if needed, refer bookmark examples:https://www.youtube.com/watch?v=PTOJC42rg_k

https://radacad.com/clear-all-slicers-in-power-bi-a-bookmark-story

Hi Amit,

Yes you are correct, my requirement is to change the bokmarks based on slicer value.

 

Hi Anand

I do know it is old post however bookmark based on slicer selection is possible. eg to show or hide some object on dash based on selection. Add measure with if statement eg if(measure="finance",1,0) . Add some visual for new measure with transparency to 100%, add it on top of your data you want to show / hide - when selected data is on then it will show white backgrond as you dash is otherwise will be transparent and will show what is behind. 
Would be better to show example I know :/, I will try to upload this logic into youtube in next 2 to 3 weeks.
 

I watched the video - thank you for the demo. Do you have any idea how this could be used if I want to replace a particular visual with another visual based on the slicer selection? Say I have a table visual displaying when the slicer has no selection, and when I make a selection with the slicer the table is replaced with a column chart in the same position the table was?

hi,, to swap charts you can do but nt with slicer selection, just with bookmarks and add object on which you click and it changes which one to show and which to hide

Did you ever create a YouTube Vid?

 

Hi StuartSmith

Here is it, I did quick example.

https://youtu.be/XZVEc-ibn6E

Thanks for this! Although the requirement is to have a bookmark to be sliced. 

I tried to do the same as what you have shown but I see a white border around the category. Is there anyway to not see this? or change it since my background isn't white.

you should be able to modify all, there is option even to transparent or set colour to the colour of your dashboard

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.