Showing results for 
Search instead for 
Did you mean: 

Relative-Date-Slicer calender weeks Mon-Sun | PageFilter work-a-round not working after publishing

Hi PBI-Team,


this issue is already reported several times....

The Relative-Date-Slicer is not able to filter calender weeks due to local week-days.

In my case the week starts on Monday and ends on Sunday.

In my date dimension table in DAX I defined a particular column (WEEKNUM([Date],2)) considering this issue. Then I defined a date column subtracting the latest week number so that I'm be able to set  a "Filters on page"-Filter (instate of the Slicer) that filters back in time (in "my" calender-weeksteps).

This work-a-round works in PBI-Desktop but after the report got published to web it indicates errors refering to the column subtracting the week numbers....


Please fix this or develop/deploy some more flexible date-slicer-filter.


Thx in advance


Status: New
Community Support

Hi @Ylreeb,


Please share the pbix file with us if possible. Do remove sensitive data in the report, then upload the pbix file to your OneDrive, paste share link here. 


Best Regards,

Qiuyun Yu