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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
ansa_naz
Continued Contributor
Continued Contributor

How to make a hidden visual cross filter other visuals?

I want to be able to do the below scenario

 

I have two visuals on a page, visual A and visual B.

Cross filter visual B from visual A

Click a bookmark, to hide visual A

Visual B still remains filtered

 

Is this possible? I have tried every bookmark option to get this to work, but am not able to do so. How can I do this please?

1 ACCEPTED SOLUTION

Hi @ansa_naz ,

 

You could use a slicer to filter the data. If just clicking the data to filter, as you shown,  the cross filtering will be removed. 

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

 

 

Best Regards,
Xue Ding
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

7 REPLIES 7
SandeepMarwal
New Member

Can somebody please explain how to remain crossfiltering intact when hiding bar chart?

parry2k
Super User
Super User

@ansa_naz you didn;;t explain the issue? What you are trying to solve?



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

ansa_naz
Continued Contributor
Continued Contributor

Hi @parry2k  Pretty much what my post says? I want to be able to hide visuals using bookmarks, but keep their crossfiltering/crosshighlighting active after they are hidden

@ansa_naz , if it hiding visual A then I think Visual B will remain. You need to have an alternate of visual B too. So when hide you hide both A and B and then show that alternate visual

 

Something very similar to reset slicers

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

ansa_naz
Continued Contributor
Continued Contributor

Hi @amitchandak what I am experiencing can be seen below - each time the Bar Chart is hidden with the bookmark, the cross filtering to the Matrix visual is removed:

 

https://imgur.com/gallery/ajjslCS

 

What I want is to be able to hide the Bar Chart visual using a bookmark, but the cross filtering from it should remain active on the Matrix visual

Hi @ansa_naz ,

 

You could use a slicer to filter the data. If just clicking the data to filter, as you shown,  the cross filtering will be removed. 

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

 

 

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

I have the same issue,and this answer is not the solution of problem,can you please help how to contain crossfiltering when hiding bar chart

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.