cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
shaileng Regular Visitor
Regular Visitor

Bookmark on slicer selection

Hi there,

 

Need some urgent help using bookmark with Slicer choice.

 

Basically I have 2 grids (Grid1 and Grid2) and 1 slicer (Slicer1)

 

If on Slicer1 "All" option is selected then  I have to show Grid1 (and hide Grid2) and if any other are item is selected on the slicer1 then I have to show Grid2 (only and hide Grid1).

 

Earlier when I used bookmark I could make use ot images and thus link bookmarks however in above case running out of ideas. Please help

1 ACCEPTED SOLUTION

Accepted Solutions
v-haibl-msft Super Contributor
Super Contributor

Re: Bookmark on slicer selection

Agree with @parry2k, we can only use measure as a workaround, but column header will not be hidden.

Attached PBIX file is a simple sample. When we select 1 in the slicer, Table1 values will be shown. If we select 2 in the slicer, Table2 values will be shown.

 

Bookmark on slicer selection_1.gif

 

Best Regards,
Herbert

3 REPLIES 3
Super User
Super User

Re: Bookmark on slicer selection

Unfortunately you cannot  select bookmark on slicer selection, currently it only works with image which you already mentioned in  your post.

 

Only work around I can think of is to create measure which you use in grid and those measure return blank values based on slicer selection, it will show blank grid but will still have headers.






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





v-haibl-msft Super Contributor
Super Contributor

Re: Bookmark on slicer selection

Agree with @parry2k, we can only use measure as a workaround, but column header will not be hidden.

Attached PBIX file is a simple sample. When we select 1 in the slicer, Table1 values will be shown. If we select 2 in the slicer, Table2 values will be shown.

 

Bookmark on slicer selection_1.gif

 

Best Regards,
Herbert

kulchandra Member
Member

Re: Bookmark on slicer selection

@v-haibl-msft

Could you please help me to achive this. I guess your answer is what i need into my data. Please see the screenshot: i want to see only on column data at the time. Is this possible in slicer like you have used in your soltuion. Any help is appriciated. 

 

 

Slicer for column names.PNG
PS: I already tried bookmark but that having too many limitations.

Thank you, Kulchandra

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 118 members 2,003 guests
Please welcome our newest community members: