Custom Date Filters

[mterry]

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 calculations. I have a spreadsheet that includes all of the dates I want to omit (with reasons). It would work doing this with DAX or in query editor. I know using a slicer is an option, but doesn't seem to be the best option for this. 

[v-sihou-msft · Accepted solution]

@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]

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