Forum Discussion
exclude rows from a slicer
I have two datasets, one with routes and one with landmarks.
The routes contain many lat / lons with timestamps, the landmarks only one set lat lon and one timestamp
Both are joined in one table
Using a slicer, i would like to filter the the routes to a particular day
This works nice, however, the landmarks are lost, as the timestamp of the landmark is outwith the slicer date
Any idea's how i could keep the landmarks in the dataset?
6 Replies
- PattemManoharCommunity Champion
patfee Please provide sample data and expected output as well.
- patfeeFrequent Visitor
something like this
Item lat lon timestamps Route #1 13.1 0.1 10-10-18 10:00 Route #1 13.11 0.1 10-10-18 10:15 Route #1 13.12 0.1 10-10-18 10:20 Landmark #1 14.0 1.1 01-10-18 00:00 Landmark #2 9.0 3.0 01-10-18 00:00 - patfeeFrequent Visitor
Expected output would be a filter on the route by date while ignoring the landmarks in the filter
- v-chuncz-msftCommunity Support
You may add a separate table for Slicer, use SWITCH Function to apply virtual relationship in DAX measure and then take advantage of Visual level filters.