Forum Discussion

visheshjain's avatar
visheshjain
Icon for Impactful Individual rankImpactful Individual
3 years ago

Filter Slicer from Measure values

Hello eveyone, I have 3 tables. Calendar, Sale and Parameter. Parameter has values ranging from 1-24, which are the number on months I want to go back. I am trying to filter a slicer which has ...
Need Help
Show and Tell
Tips and Tricks
johnt75's avatar
johnt75
Icon for Super User rankSuper User
3 years ago

You need another measure like

Date is visible =
IF ( SELECTEDVALUE ( 'Date'[Date] ) IN CALENDAR ( [Min date], [Max date] ), 1 )

and use that as a visual level filter on the slicer.

  • visheshjain's avatar
    visheshjain
    Icon for Impactful Individual rankImpactful Individual
    3 years ago

    Hi johnt75,

     

    The visual is giving an error.

     

    P.S. 2 step and 1 step are my start and end dates.

    • johnt75's avatar
      johnt75
      Icon for Super User rankSuper User
      3 years ago

      what does it show if you click on "see details" ?

      • visheshjain's avatar
        visheshjain
        Icon for Impactful Individual rankImpactful Individual
        3 years ago

        As you can see the start and end dates are not blank as shown in the card visual below.