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!

     

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!

      • FADAVI's avatar
        FADAVI
        Frequent Visitor
        10 months ago

        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