Forum Discussion
telesnate
1 year agoRegular Visitor
Relative Date Slicer (Skipping Weekends)
Hi there, I have a report with data that is only created on weekdays. I have no weekend data whatsoever. I have a relative date slicer and when I set it to "last 1 day", I want it to show me...
- 1 year ago
I would create a flag on my data table that identified the last date. If your fact table does not have data at all on the weekends and thus you want to show the most recent weekday with data
Flag_Day_Prior = IF('Date_Table'[Date] = MAX(Fact_Table[Date]),1,0)
Add this field to your measure as a filter and set it = 1
Please mark this post as solution if it helps you. Appreciate Kudos.
- 1 year ago
Hi telesnate
The Relative Date slicer in Power BI does not support filtering to include only weekdays or weekends within the past X days.
This question has already been addressed previously.
Please refer to the following resources for more details: