Forum Discussion

mterry's avatar
mterry
Helper V
8 years ago
Solved

Custom Date Filters

I'm trying to figure out the best way to add a custom date filter. I'm looking at certain number counts by day, but there are some particular days I want to omit from the visualizations and the calcu...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    8 years ago

    mterry

     

    Currently, it's not possible to make a Relative Date Slicer, which is based on a custom filtered Date list. The build-in date slicer can only be based on a full calendar.

     

    For your requirement, you may try to use Power Query to conver the date into a number. Then apply a TOP N filter to get expected results. I can't find a more "friendly" way to achieve it. 

     

    Regards,

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
8 years ago

mterry

 

Currently, it's not possible to make a Relative Date Slicer, which is based on a custom filtered Date list. The build-in date slicer can only be based on a full calendar.

 

For your requirement, you may try to use Power Query to conver the date into a number. Then apply a TOP N filter to get expected results. I can't find a more "friendly" way to achieve it. 

 

Regards,

mterry's avatar
mterry
Helper V
8 years ago

Okay - maybe I'll just try to remove all applicable dates in the query editor