Hello BI Super Users,
So I have very particular requirement to map data points with the help of Latitude and longitude. I have 2 data sets, one employee with Lat and Lon, second locations with Lat and Lon. These data sets have another column as type to differentiate between employee and locations and color then differently. Now the datasets have been merged into one. Got 3 slicers. 1) where we be able to select all the employee or locations (the same type column I was refering to), second slicer for all employees to be able to select an option, third for locations. When I click on one slicer, say all employee, all the other slicers go blank.
The workaround is to edit interactions and disable them for all 3 slicers. Worked perfectly as I wanted. However, now when I click 1 location, it is mapped perfectly and I can see other options in other slicers, so now I click all employee to be able to see which employees are closer, however, the map goes blank with the selected location disappearing too.
Ihv looked everywhere and apparently, still have not been able to find a solution that actually works 100% although the interaction thing worked fine.
