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
I have a single table with Value1 and Value2 values, for example:
Value1 - Value2
A - B
B - C
B - D
C - E
The relationships do not apply in a particular direction, and visualising this using something like a Forced-Directed Chart shows the relationships quite well. You can see how it shows all the relationships with B, irrespective as to whether B is in Value1 or Value2.
But the data needs to be filtered by B and if I base the filter on Value1, then I will only see the relationships with C and D, and conversely, if I base the filter on Value2, then I will only see the reltionship with A. I need to be able to select B and show A, C and D.
I think what I need do is to ensure all distinct values across Value1 and Value2 and represented in (for example) Value1 and for all its relationships to appear in Value2. Something like
Value1 - Value2
A - B
B - A
B - C
B - D
C - B
C - E
D - B
E - C
Is this the solution, and could such a dataset be derived?
Solved! Go to Solution.
Hi @Etienne123
The solution you have suggested is presumably the best, and it's easy to achieve both in Power Query and using DAX.
I've attached a file with both solutions, let me know if you need any explanation.
Hi @Etienne123
The solution you have suggested is presumably the best, and it's easy to achieve both in Power Query and using DAX.
I've attached a file with both solutions, let me know if you need any explanation.
Before I saw this, I ended up doing somethikng similar to the PQ soluition, but I really like the DAX UNION method.
Thanks!!
Hi @Etienne123
I'm glad you like it, just a few things to pint out here, the best practice is to do your transformation is PQ.
However, with smaller models, it shouldn't make much of a difference.
Thanks
Mariusz
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.