Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
146 | |
87 | |
66 | |
52 | |
46 |
User | Count |
---|---|
215 | |
90 | |
83 | |
66 | |
58 |