Forum Discussion

FADAVI's avatar
FADAVI
Frequent Visitor
10 months ago
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...
  • BeaBF's avatar
    BeaBF
    10 months ago

    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!

     

BeaBF's avatar
BeaBF
Super User
10 months ago

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!

 

  • FADAVI's avatar
    FADAVI
    Frequent Visitor
    10 months ago

    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

    • BeaBF's avatar
      BeaBF
      Super User
      10 months ago

      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!

      • FADAVI's avatar
        FADAVI
        Frequent Visitor
        10 months ago
        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])
            )