Forum Discussion
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 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.
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,
2 Replies
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,
Okay - maybe I'll just try to remove all applicable dates in the query editor
