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! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





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! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





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.

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 98 members 1,538 guests
Please welcome our newest community members: