Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
patfee
Frequent Visitor

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 6
patfee
Frequent Visitor

something like this

 

Itemlat lontimestamps
Route #113.10.110-10-18 10:00
Route #113.110.110-10-18 10:15
Route #113.120.110-10-18 10:20
Landmark #114.01.101-10-18 00:00
Landmark #29.03.001-10-18 00:00
patfee
Frequent Visitor

Expected output would be a filter on the route by date while ignoring the landmarks in the filter

@patfee,

 

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.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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 

PattemManohar
Community Champion
Community Champion

@patfee Please provide sample data and expected output as well.





Did I answer your question? Mark my post as a solution!

Proud to be a PBI Community Champion




Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors