Desktop

[sjpark1989]

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.

[v-cherch-msft]

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