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,
How can visualize the link between data, in a single table.
Here is a very simple example :
COL1 | COL2 |
A | XX |
B | XX |
C | XX |
A | YY |
E | YY |
F | XX |
F | YY |
H | YY |
I | XX |
J | YY |
M | YY |
M | YY |
M | XX |
N | XX |
In this exemple, the cells in bold and green are common between YY and XX.
What type of visualise (or calculation two), can I use to only see the value in common ?
I tries to used the "forced directed graph" (from Microsoft), but I don't know how to filter value in common only (so the graph is unreadable).
The value are not that, but my table is realy like that, with millions of lines, but with only few in common, I want to visualize.
Thanks for your help and advices
Solved! Go to Solution.
the one on the right, when you selected from slicer, xx and yy , it will filter out and leave only the values that have xx and yy in comon .
## -############
## -############
## -############
the one on the left , will show which values have common data from the other column . ( not affected by slicer) (this is somewhat complex )
If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. I would appreciate hitting that kudos button 👍🤠
the one on the right, when you selected from slicer, xx and yy , it will filter out and leave only the values that have xx and yy in comon .
## -############
## -############
## -############
the one on the left , will show which values have common data from the other column . ( not affected by slicer) (this is somewhat complex )
If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. I would appreciate hitting that kudos button 👍🤠
I tried creating a table (with two formulas : , with the agregation and the count (STEP 3 above), but on STEP 4, it is always filtered by the row context :
Hi @Greg_Deckler ,
Thanks for your proposition. It is not working, probably because of the line context. But it may me think of an other way : how can I exclude the row context from the calculation.
I am thinking of using the DISTINCT on COL1, after being SUMMERIZED with your formula. Something like that, steps by steps :
Thanks for your help.
Regards,
@TheBigFrench Well, you could create a measure that you can filter on. Something as simple as:
Common = COUNTROWS(SUMMARIZE('Table', [COL1], [COL2]))
You could then filter for when Common = 2
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 |
---|---|
103 | |
101 | |
87 | |
73 | |
67 |
User | Count |
---|---|
116 | |
109 | |
94 | |
79 | |
72 |