Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to Solution.
Hi @MKM ,
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.
Hi @MKM ,
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.
If you pick a particular month it is no longer a relative selection.
User | Count |
---|---|
121 | |
72 | |
71 | |
57 | |
50 |
User | Count |
---|---|
167 | |
83 | |
68 | |
65 | |
55 |