Forum Discussion
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 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
10 Replies
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 toHave a good one.
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
ClickedOrMaxBBF
💡 Did I answer your question? Mark my post as a solution!
👍 Kudos are appreciated
🔥 Proud to be a Super User!
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 2025FADAVI 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!
