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 ...
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 |
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.
Thanks Sam
would you plz be so kind to add some more detail?
I'm not yet knowlagable enouch to work out a solution based on your direction
Thanks
Patrick