Forum Discussion
Prevent Filter reset when clicking into table
I've 2 visuals in my PowerBI Report page: a table and an image grid (btw this is a cool thing!:)
Clicking on image grid filters the table and shows me the desired informations.
I only want to have this 'uni-directional', I configured the Interaction between that 2 visuals accordingly.
I can work with the filtered table like scolling, sorting acc. to column, clicking on some links, etc...
So far so good.
But Problem is: clicking on any item/cell (except cells with URL symbol included) in the table resets the filter and the whole table is shown.
Is there a way to prevent this and keep that table somehow 'static' ?
I want to control the table only by the image grid, it should only work as a informational block (with the features mentioned above)
15 Replies
Still frustrated by this in 2024. I have a table that is only visible when a different visual has been used to navigate into a certain context. I want that table visual to show just child items from the first and for a drilldown function only. I don't want the user to click on a row (which they will do if they want to highlight it for reading purposes) and subsequently have all the filters reset on them and leave with an empty 2nd table.
Did you happen to find a solution? I am running up against the same request and challenge
Did anyone ever find a solution to this? I am frustrated by the same phenomenon - it seems it should be something as easy as freezing filter action only interacting with the table in question, and not something so clunky as putting an invisible shape on top of the table.
Catrice ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
If you right-click use include the filter will remain unless you remove
Appreciate your Kudos.Here's a movie that shows my problem:
https://drive.google.com/file/d/1usepwjDfjL6-x95Y6e3wJU0HzQqv8LpV/view?usp=sharing
I don't want that the filter is reset when I click somewhere in the table!
Hope it makes it clear.
Hi Catrice ,
The link you shared is not public,pls share us a public link.
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
I have the same problem. Clicking a value in Bar Chart 1 filters Bar Chart 2. Bar Chart 2 filters a table. But when I click in Bar Chart 2 to filter the table, the click resets the selection in Bar Chart 1. Relationship is set to one-way.
