topic Re: Remove visual filter context in DAX Commands and Tips

Remove visual filter context

FADAVI — Wed, 15 Oct 2025 13:29:56 GMT

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 value in my min function.
I don't want to edit interraction from the table to the card because I need to capture the clicked value in the table as a max.

The all() function didn't helped me because It totally removes the slicer filter. So it shows me the 01/01/2024

In few words:
If no click on the table
MIN = min slicer
MAX = max slicer

If click on a value of the table
MIN = min slicer
MAX = clicked value

Thanks for your help

Re: Remove visual filter context

BeaBF — Wed, 15 Oct 2025 13:37:27 GMT

FADAVI Hi!

Try with:

RedCard_Value :=
VAR MinSlicer =
CALCULATE(
MIN('Table'[Date]),
REMOVEFILTERS('Table'[Date]) -- ignore table click, keep slicer
)
VAR ClickedOrMax =
IF(
HASONEVALUE('Table'[Date]),
SELECTEDVALUE('Table'[Date]), -- clicked value
CALCULATE(MAX('Table'[Date])) -- max from slicer
)
RETURN
ClickedOrMax

BBF

💡 Did I answer your question? Mark my post as a solution!

👍 Kudos are appreciated

🔥 Proud to be a Super User!

Re: Remove visual filter context

FADAVI — Wed, 15 Oct 2025 13:47:57 GMT

Thanks for your answer. It will not show the min value of the slicer. It will show the min value of the whole date column.
In my example I set the slicer value from 01/01/2025 to 31/12/2025. Your measure will show the first of january of 2024 instead of 2025

Re: Remove visual filter context

BeaBF — Wed, 15 Oct 2025 13:53:08 GMT

FADAVI Retry with:

RedCard_Value :=
VAR MinSlicer =
CALCULATE(
MIN('Table'[Date]),
ALLSELECTED('Table'[Date]) // keep slicer, ignore table click
)
VAR Clicked =
SELECTEDVALUE('Table'[Date])
RETURN
IF(
HASONEVALUE('Table'[Date]),
Clicked, // when user clicks in table
MinSlicer // when nothing clicked
)

BBF

💡 Did I answer your question? Mark my post as a solution!

👍 Kudos are appreciated

🔥 Proud to be a Super User!

Re: Remove visual filter context

FADAVI — Wed, 15 Oct 2025 14:00:14 GMT

VAR Clicked =

SELECTEDVALUE('calendar'[Date])

Will not give me the min but the actual clicked value

And your first var is the one I originnaly used

CALCULATE(

MIN('calendar'[date]),

ALLSELECTED('calendar'[date])

)

Re: Remove visual filter context

BeaBF — Wed, 15 Oct 2025 14:04:21 GMT

FADAVI So I don't know if I undestood your request, can you better explain it?

RedCard_Value :=
VAR SlicerRange =
CALCULATETABLE(
VALUES('calendar'[Date]),
ALLSELECTED('calendar'[Date])
)
VAR MinSlicer =
CALCULATE(
MIN('calendar'[Date]),
REMOVEFILTERS('calendar'[Date]),
KEEPFILTERS(TREATAS(SlicerRange, 'calendar'[Date]))
)
VAR ClickedValue =
SELECTEDVALUE('calendar'[Date])
RETURN
IF(
HASONEVALUE('calendar'[Date]),
ClickedValue, -- When a table value is clicked
MinSlicer -- When nothing is clicked
)

BBF

💡 Did I answer your question? Mark my post as a solution!

👍 Kudos are appreciated

🔥 Proud to be a Super User!

Re: Remove visual filter context

FADAVI — Wed, 15 Oct 2025 14:12:09 GMT

Ok let's explain it another way.
I want all the dates in the range set in the slicer.
I want when I click in the table to be able to have a range from the start of the slicer to the clicked value in the table, for another visual that used both of these values.

So I want MIN to be always the same and MAX to be either the one in the slicer or if I click on a value the selected value.

I want my MIN value to keep being the first value of the slicer it means removing the visual filter context when I click on value

Re: Remove visual filter context

BeaBF — Wed, 15 Oct 2025 14:29:40 GMT

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!

Re: Remove visual filter context

FADAVI — Wed, 15 Oct 2025 14:37:55 GMT

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

Re: Remove visual filter context

FADAVI — Wed, 15 Oct 2025 15:05:54 GMT

You're the one !! Thanks a lot.
It seems to work .

I will try to make it work in my real use case.

I just don't understand what you did, I will try to

Have a good one.

Re: Remove visual filter context

BeaBF — Wed, 15 Oct 2025 15:09:16 GMT

FADAVI Here an updated PBIX, in the previous there was a bug.

If it fix your problem, please accept this answear as a solution!

BBF

💡 Did I answer your question? Mark my post as a solution!

👍 Kudos are appreciated

🔥 Proud to be a Super User!