Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Date time range filter for map visual

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-fil...
Help me please
  • v-xiaotang's avatar
    v-xiaotang
    3 years ago

    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.