topic Re: Date time range filter for map visual in DAX Commands and Tips

Date time range filter for map visual

Anonymous — Tue, 18 Oct 2022 12:01:49 GMT

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?

Re: Date time range filter for map visual

v-xiaotang — Wed, 19 Oct 2022 08:58:20 GMT

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.

Re: Date time range filter for map visual

Anonymous — Wed, 19 Oct 2022 16:23:27 GMT

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.

Re: Date time range filter for map visual

v-xiaotang — Wed, 02 Nov 2022 06:58:42 GMT

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.