Forum Discussion
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), a dimension table (or master) and a facts table (or detail), related one-to-many.
- I have created two table visuals, each one showing the fields of each model table.
- When I select a row in the table visual for dimensions, only the related rows in the table visuals for facts are showed. That is the normal behaviour of Power Bi.
- But when I select a row (or rows) in the table visual for facts, the table visuals for dimension is not filtered, showing only the related ones.
Is there any way to achieve this filter 'many-to-one'?
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:
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
3 Replies
OMG! That's IT. I've been DAYS struggling with that, tryin a lot of DAX, when this was the PERFECT and SIMPLE solution.
And you answered in a couple of minutes!
Thanks!!! ^_^ 😀
Ah!... I have just watched the video and the article you recommended me and are AMAZING! 👍👍👍
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:
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/DenSelimovicGo to the Model tab and edit the relationship between the two tables.
You should be able to update the cross filter direction for the table relationship to "both", which will accomplish what you want.
