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])
          )
      • BeaBF's avatar
        BeaBF
        Super User
        10 months ago

        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!