Date time range filter for map visual

[Anonymous]

Actually, I have created a date time range filter and implemented them for measures with the help of the link given below.

https://exceed.hr/blog/including-hours-and-minutes-in-dax-date-filters/

But when I added maps to my report, the above filter didn't work. Actually, filters work for measures with conditions given in that measure.  But now I require a filter for a column instead of measure. I am providing an id column in the location field of Mapbox. How do I provide ids filtered by date and the time range in the location field? So that the filter works. Or is there any better approach?

[Anonymous]

Thanks for the reply but actually this is not the issue.. I can have date time range filter in the filter pane but I need that in slicer. Actually that is our clients requirement.

[v-xiaotang · Accepted solution]

Hi @Anonymous 

Thanks for your reply.

>> But now I require a filter for a column instead of measure. I am providing an id column in the location field of Mapbox. How do I provide ids filtered by date and the time range in the location field? 

Actually I mean, filter your id column by creating a filter measure and put it in visual-level filter, for example,

create the measure below

filter measure = IF( MIN('Table'[Start Date])>=SELECTEDVALUE('date 1'[Date]) && MIN('Table'[End Date])<=SELECTEDVALUE('date 2'[Date]),1,0)

result

please see the sample file attached below

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[v-xiaotang]

Hi @Anonymous 

Thanks for reaching out to us.

you can try visual-level filter, Add a filter to a report in Power BI - Power BI | Microsoft Learn

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.