Forum Discussion
Helper IRelative Date Slicer to Exclude Today
Hi all,
On one of my reports, I have a relative date slicer for end users to view historical data.
Our data syncs one day in arear though (4/13 we load 4/12 data and so on). So by default I'd prefer to have today excluded, similar to the option in the filters pane. But I havent been able to figure out how to accomplish this with the slicer.
My current workaround is to have a separate filter pane slicer that effects all the visuals and excludes today. But this still isnt ideal to use two separate filters.
Hi MPetramalo214 ,
Suppose there is a [Date] column in data table, and may be you can create a calculated column:
New Date=IF([Date]=Today(), BLANK(), [Date])Then, add this [New Date] column to visual level filter or page level filter, set it fiter syntax to "is in this month".
MPetramalo214 -> Please hit the thumbs up & mark it as a solution if it helps you. Thanks.
1 Reply
- truptis
Community Champion
Hi MPetramalo214 ,
Suppose there is a [Date] column in data table, and may be you can create a calculated column:
New Date=IF([Date]=Today(), BLANK(), [Date])Then, add this [New Date] column to visual level filter or page level filter, set it fiter syntax to "is in this month".
MPetramalo214 -> Please hit the thumbs up & mark it as a solution if it helps you. Thanks.