Forum Discussion

bklyn3's avatar
bklyn3
Advocate II
3 years ago
Solved

Selecting two values from one column

Hello,

 

i have a table with 3 columns :
City, Latitude, Longitude

I would like to have 2 slicers : one called Origin, the other destination

Then I would use Latitude and longitude to output the distance between the selected two  cities. 

My issue is that if I use two slicers from the same column City,  when the user select the origin, the second slicer sync and the destination slicer has only one option : the origin  city. Though this makes the calculation of distance quiet simple, that's not meeting my desing intent.

Is there a simple way to have two slicers picking up two value from the same column ? 

Thank you