Selecting two values from one column

bklyn3 — Thu, 13 Oct 2022 13:08:08 GMT

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

Re: Selecting two values from one column

Anonymous — Thu, 13 Oct 2022 14:28:39 GMT

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-desktop

topic Selecting two values from one column in DAX Commands and Tips

Selecting two values from one column

Re: Selecting two values from one column