This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
Can i filter some points by date while leaving other points always visible on map?
When using the Arc map i have to put every Long/lat point in the same excel file to be able to plot them all on the map at the same time. i have three different catagories in my spreadsheet: Home adresses (black), construction site addresses(blue/purple), and GPS time card "clock-ins"(pink) . the clock ins have a date attached to them in a date column, but the other two catagories do not. when i filter these on the map the construction sites and the home addresses go away. is there a way i can keep them permanently on the map so the only points being filtered with the date slicer is the clock-ins ( the only catagory that has dates in the spreadsheet)
Solved! Go to Solution.
You may drag measure below to Size.
Measure =
VAR d =
SELECTEDVALUE ( Table1[date] )
RETURN
IF ( ISBLANK ( d ) || d IN VALUES ( Table2[date] ), 1 )
You may drag measure below to Size.
Measure =
VAR d =
SELECTEDVALUE ( Table1[date] )
RETURN
IF ( ISBLANK ( d ) || d IN VALUES ( Table2[date] ), 1 )
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 30 | |
| 24 | |
| 23 | |
| 17 | |
| 16 |
| User | Count |
|---|---|
| 61 | |
| 35 | |
| 29 | |
| 23 | |
| 22 |