Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
syandamuri91
New Member

Filtering data from two different tables

‎10-25-2017 02:12 PM

Hi ,

 

I have 3 tables A,B,C and A and B have a relationship connecting them and B and C are also connected. But when I use column in a slicer from table A over to filter table C data, It is not filtering.

I have tried and column from B in the slicer is filtering for both the tables A and B individually.

 

So the relationship is like  A--many to one-->B<--many to one--C

A can filter B , B can filter A ,C and C can filter B

but A is not able to filter C or vice versa.

 

Is there anyway to solve this issue?

 

Thanks.

Message 1 of 4
977 Views
0
3 REPLIES 3
parry2k
Super User
Super User

‎10-25-2017 03:35 PM

You can achieve this by changin relationship Cross Filter Direction, change it to Both as shown below.

 

both relation.PNG



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.

Message 3 of 4
963 Views
0
erik_tarnvik
Solution Specialist
Solution Specialist
In response to parry2k

‎10-25-2017 06:37 PM
Apparently I had old info. Every day you learn something new is a good day. 🙂
Message 4 of 4
956 Views
0
erik_tarnvik
Solution Specialist
Solution Specialist

‎10-25-2017 02:41 PM
This is expected behavior, filter contexts only propagate in the one to many direction. There are always solutions, the best one usually being remodeling your data into a Star schema using Power Query. More specific advise would require more details on your data model.
Message 2 of 4
971 Views

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

View All