Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
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?
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
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
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
@patfee Please provide sample data and expected output as well.
Proud to be a PBI Community Champion
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 81 | |
| 49 | |
| 36 | |
| 31 | |
| 30 |