Forum Discussion
Solved
Remove visual filter context
Hi, I want that whatever the value I click in the table on the left, the red card on the right show the min value of the slicer above. I wasn't able to make it work cause it shows me the clicked va...
FADAVI ok, try with:
Min_Slicer_Date :=
VAR SlicerRange =
CALCULATETABLE(
VALUES('Calendar'[Date]),
ALLSELECTED('Calendar'[Date]) // gets only the slicer range
)
VAR MinSlicer =
CALCULATE(
MIN('Calendar'[Date]),
REMOVEFILTERS('Calendar'[Date]), // remove visual filters (table click)
KEEPFILTERS(TREATAS(SlicerRange, 'Calendar'[Date])) // reapply slicer range
)
RETURN
MinSlicer
BBF
💡 Did I answer your question? Mark my post as a solution!
👍 Kudos are appreciated
🔥 Proud to be a Super User!
TY again for your help, I appreciate. It's a tricky problem. I doesn't work either.
On the screenshot bellow I clicked on 03/01/2025. It should have been 01/01/2025 in your card