Forum Discussion
Need some clarrification on Relative Date Slicer
Hi Team,
Please check and give me details on the Relative Date Slicer.
If we select last 2 month In this Slicer how we can select only "May ". how we can select selective past month, kindly check and do the needful
Hi Anonymous ,
It can't be achieved directly in relative slicer, here's my workaroud:
Create a measure as below:
Measure = IF ( DATEDIFF ( MAX ( 'Table'[Date] ), TODAY (), MONTH ) = 2, 1, 0 )Put it in the visual filter and select show items when the value is 1.
After click apply filter, get the correct result:
Best regards,
Community Support Team_yanjiang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
v-yanjiang-msftCommunity Support
Hi Anonymous ,
It can't be achieved directly in relative slicer, here's my workaroud:
Create a measure as below:
Measure = IF ( DATEDIFF ( MAX ( 'Table'[Date] ), TODAY (), MONTH ) = 2, 1, 0 )Put it in the visual filter and select show items when the value is 1.
After click apply filter, get the correct result:
Best regards,
Community Support Team_yanjiang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- lbendlin
Super User
If you pick a particular month it is no longer a relative selection.
