Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Is there any way to achieve this filter 'many-to-one'?
Solved! Go to Solution.
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
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! 👍👍👍
Go 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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |