Forum Discussion

Francisco_G_Cal's avatar
Francisco_G_Cal
Helper I
4 years ago
Solved

Filter dimension table visual when selecting in fact table visual

Hi As much as I can see, the filtering in table visuals for one-to-many relations works on direction one-to-many, but not in the inverse direction. I'll explain myself. I have two tables (model), ...
Need Help
selimovd's avatar
selimovd
Most Valuable Professional
4 years ago

Hey Francisco_G_Cal ,

 

you can configure which tables is filtered by which other table with the filter direction:

https://radacad.com/what-is-the-direction-of-relationship-in-power-bi

 

However if you set all relationships to bidirectional you can get results you don't want and a bad performance. Check the article of Nikola Ilic:

https://towardsdatascience.com/killing-me-softly-bi-directional-relationships-in-power-bi-b6b0b9e150f4

 

The best way is to filter the visuals by a DAX measure. Check the following video, here it's described in detail:

https://www.youtube.com/watch?v=1yv5srlqgmI

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic