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-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?

 

 
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.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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's avatar
      v-xiaotang
      Community Support
      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.