Forum Discussion
Manipulate date slicer behaviour with Graph visual
- Anonymous1 year ago
Hi AshishTanwar88 ,
Based on the testing, try using the following DAX formula.
Is not today = IF(MAX('Table'[Date]) = TODAY() && MAX('Table'[Date]) > TODAY() - 3, 1, IF(MAX('Table'[Date]) >= TODAY() - 3 && MAX('Table'[Date]) < TODAY(), 1, 0) )Then, drag the measure to the table visual filters pane and set the show item is 1.
Besides, set the measure for the slicer visual.
You can also view the following link to learn more information.
Solved: Required custom date Slicer Last 7 days,last 15 da... - Microsoft Fabric Community
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.
Hi AshishTanwar88 ,
Based on the testing, try using the following DAX formula.
Is not today =
IF(MAX('Table'[Date]) = TODAY() && MAX('Table'[Date]) > TODAY() - 3, 1,
IF(MAX('Table'[Date]) >= TODAY() - 3 && MAX('Table'[Date]) < TODAY(), 1, 0)
)
Then, drag the measure to the table visual filters pane and set the show item is 1.
Besides, set the measure for the slicer visual.
You can also view the following link to learn more information.
Solved: Required custom date Slicer Last 7 days,last 15 da... - Microsoft Fabric Community
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.