cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
barabum Frequent Visitor
Frequent Visitor

Cross-Filtering Issue

I have two tables: Products and Categories.

There is Many to one relationship between Products and Category.  Cross filter direction is set to Single.

 

I put two Table visuals on a page. The idea is that one table will show categories. When user clicks on a category, it shows products in the second table.

By default, when I click on a row in Category table, it filters products. It is expected.

The problem is that when after selecting a category I select a product, it resets selected row in Categories table, which leads to updating Products table that shows products from all categories afterwards. Updating Products table to set interaction to None for Categories table didn't help.

 

Is there a way to disable any affect on cross-filtering for Products table? I just want a user to be able to click on a product without any side effects.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Cross-Filtering Issue

@barabum use can use ctrl + click for filter not to reset on category table but better solution will be to use slicer visual for category until there is a reason that you have to use table visual




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

Proud to be a Datanaut!

www.perytus.com
(MVP Data Platform)


3 REPLIES 3
barabum Frequent Visitor
Frequent Visitor

Re: Cross-Filtering Issue

Up

Super User
Super User

Re: Cross-Filtering Issue

@barabum use can use ctrl + click for filter not to reset on category table but better solution will be to use slicer visual for category until there is a reason that you have to use table visual




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

Proud to be a Datanaut!

www.perytus.com
(MVP Data Platform)


Community Support Team
Community Support Team

Re: Cross-Filtering Issue

Hi @barabum,

 

The suggestion of parry2k should be helpful.

 

If you have solved your problem, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.