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.
I have a dataset that looks like this:
Origin | Destination | Trips |
A | B | 3 |
A | C | 4 |
B | A | 5 |
B | C | 6 |
C | A | 9 |
C | B | 6 |
I also have the coordinates for A, B and C. I'm trying to create a map visual whereby if I click on A, all destinations originating from A gets filtered.
I thought pivoting the destination column will work, but then I realized that I will lose my coordinates for my destinations by doing so. How do I achieve my desired visualization?
Thanks.
Hi @sjpark1989
Could you explain more about your expected output? If you click on A, it will show B,C? If so, you may refer to below picture and use the drill mode.
Regards,
Cherie
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 |
---|---|
110 | |
97 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |