Forum Discussion
AshishTanwar88
1 year agoFrequent Visitor
Manipulate date slicer behaviour with Graph visual
Hi All, Currently, In the date slicer, we are choosing the last three days then the date range showing as "12/14/2024 to 12/16/2024" which is correct. And if there is no data available for 12/16/...
- 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.
lbendlin
1 year agoSuper User
Filter your calendar table by the TOPN(3,..) of the data dates, using TREATAS or calculated columns if you do daily refreshes.