Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Drop down box to filter two dates

Hi everyone,   I am setting up a report page with multiple charts. I want to have on the left of the page two drop down boxes with start date to filter and then end date so people can choose which ...
Need Help
  • Samarth_18's avatar
    Samarth_18
    5 years ago

    For filtering second drop down based on first you can create a measure as below and use it as visual level filter on visual.

    end_date_filter =
IF ( MAX ( _end_date[Date] ) >= SELECTEDVALUE ( _start_date[Date] ), 1, 0 )

    And sorting your dates make sure you have marked your date column type  as date from ribbon.

     

    Once you set it as date and click elipsis(three dot) of slicer you will get sort option like below. so you can use it for sorting according to your need.

     

     

     

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks Samarth

 

When I do the steps above my second drop down box only lets me select the date in the first drop down box. The second drop down box filters on the first drop down box. Also the date ordering is alphabetical not cronological. How do I change that?

 

Thanks

  • Samarth_18's avatar
    Samarth_18
    Community Champion
    5 years ago

    For filtering second drop down based on first you can create a measure as below and use it as visual level filter on visual.

    end_date_filter =
IF ( MAX ( _end_date[Date] ) >= SELECTEDVALUE ( _start_date[Date] ), 1, 0 )

    And sorting your dates make sure you have marked your date column type  as date from ribbon.

     

    Once you set it as date and click elipsis(three dot) of slicer you will get sort option like below. so you can use it for sorting according to your need.