Forum Discussion
Relative date filter for week(mon-sun)
Hi, I have relative date filter set up for calendar week.
The problem is that week is Sunday - Monday.
If I try to set to just a week option it becomes just moving moving week by day what is even worse.
This is what I have.
The additional problem is that data that I am working on is Live connection model so I can't do any column modification and I am locked only to using measures.
Anyone know if there is any way I can solve this problem?
Thanks
6 Replies
As you can check here Microsoft Idea
I think you can't do it using that filter. You should do it with a calculated column or measure but not using the "relative date filter pane" as i KnowGabry Since I can only create measures and not calculated columns it would be great if you know how I can do it with a measure.
Since as far as I know you cant use measures in a filters.Maybe you can do something like this
Measure = if(selectedvalue(date)>today()-7,1,0) then put the filter always on 1
just thinking, you have to adjust and test if it works
Hi Justas4478 ,
First of all, many thanks to Gabry for your very quick and effective replies. Based on my testing, the relative date range is default from Sunday to Saturday.
Please try the following methods as workaround:
Create the slicer relative date.
View the following document to learn more about relative date.
Create a relative date slicer or filter in Power BI - Power BI | Microsoft Learn
You can also raise a new idea and add the comments there to make this feature coming sooner.
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous Last 1 'Weeks' is a mowing week by 1 day.
The best that I could work out was to use This week.It is still sunday to saturday but it is best I could get from available options.
