Forum Discussion

Amir851's avatar
Amir851
Helper I
7 years ago
Solved

Need Help in Slicer selection

I have below the table in my Data model. Items Certificate Last Date Today Days Diff Timeline Item1 Certificate 1 27 Oct 2019 01 Apr 2019 209  Under 1 Year Item2 Certificate 2 2...
  • v-cherch-msft's avatar
    7 years ago

    Hi Amir851 

    You may create a slicer table and then create a measure like below.Then use it in visual level filter.Attached sample file for your reference.

    Measure = 
    IF (
        HASONEVALUE ( Slicer[slicer] ),
        IF (
            SELECTEDVALUE ( Slicer[slicer] ) = "Under 1 Year",
            IF ( MAX ( Table1[Timeline] ) = "Under 1 Year", 1 ),
            IF (
                SELECTEDVALUE ( Slicer[slicer] ) = "Under 5 Years",
                IF ( MAX ( Table1[Timeline] ) IN { "Under 1 Year", "Under 5 Year" }, 1 ),
                IF (
                    SELECTEDVALUE ( Slicer[slicer] ) = "Greater than 5 Years",
                    IF ( MAX ( Table1[Timeline] ) = "Greater than 5 Year", 1 )
                )
            )
        )
    )
    

    Regards,