Forum Discussion
Relative Date Filter automatically changes from months to days
Hi Anonymous
Here is a workaround.
Create measures, then add [flag] in the visual level filter
In my example, today=2019/1/25
today = TODAY() today-year = YEAR([today]) today-month = MONTH([today]) flag = IF ( MAX ( 'Table'[year] ) = [today-year] && MAX ( 'Table'[month] ) = [today-month] && MAX ( 'Table'[Date] ) < [today], 1, 0 )Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community SupportHi Anonymous
Here is a workaround.
Create measures, then add [flag] in the visual level filter
In my example, today=2019/1/25
today = TODAY()
today-year = YEAR([today])
today-month = MONTH([today])
flag =
IF (
MAX ( 'Table'[year] ) = [today-year]
&& MAX ( 'Table'[month] ) = [today-month]
&& MAX ( 'Table'[Date] ) < [today],
1,
0
)
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Somehow this does not work for me. Maybe, I did something wrong. Nevertheless, I created a workaround myself by making an extra calculated column.
I was more interested why this standard functionality (using the in built relative date filtering) did not work at first hand.
- v-juanli-msft
Hi Anonymous
Very interested how you created a workaround by making an extra calculated column.
As tested, if i click on the "Apply filter" after setting the relative slicer, then next time the "Apply filter" should become grey.
If i don't click on it after setting, it shows as your screenshot to be yellow.
Best Regards
Maggie