Selecting two values from one column

[bklyn3]

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 

[Anonymous · Accepted solution]

hi,

you have to stop the refresh on the second slicer when the 1rst one is hit

https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers?tabs=powerbi-deskt...