Need Help in Slicer selection

[Amir851]

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	23 Mar 2020	01 Apr 2019	357	Under 1 Year
Item3	Certificate 3	23 Mar 2020	01 Apr 2019	357	Under 1 Year
Item4	Certificate 4	12 Apr 2019	01 Apr 2019	11	Under 1 Year
Item5	Certificate 5	17 Jul 2019	01 Apr 2019	107	Under 1 Year
Item6	Certificate 6	17 Jul 2019	01 Apr 2019	107	Under 1 Year
Item7	Certificate 7	30 Sep 2019	01 Apr 2019	182	Under 1 Year
Item8	Certificate 8	09 Dec 2019	01 Apr 2019	252	Under 1 Year
Item9	Certificate 14	01 Oct 2023	01 Apr 2019	900	Under 5 Year
Item10	Certificate 10	03 Aug 2019	01 Apr 2019	124	Under 1 Year
Item11	Certificate 14	01 Oct 2023	01 Apr 2019	900	Under 5 Year
Item12	Certificate 12	11 Nov 2019	01 Apr 2019	224	Under 1 Year
Item13	Certificate 13	19 Jun 2019	01 Apr 2019	79	Under 1 Year
Item14	Certificate 14	01 Oct 2023	01 Apr 2019	900	Under 5 Year
Item15	Certificate 15	19 Jun 2019	01 Apr 2019	79	Under 1 Year

I have two slicers named as Timeline and Items in my report

Slicer named as Timeline has following below values

• Under 1 Year
• Under 5 Years
• Greater than 5 Years

If I select  Under  I Year  in Timeline slicer it shd filter Item slicer and Display a list of particular Items in a visual which is under 1 Year in a table, But If I select Under 5 Years then

it shd display the items under both 1 Year and 5 Years in a visual and also filter Items slicer according to it.

I am not sure how to do it 

[Ashish_Mathur]

Hi,

In the Timeline slicer, select both "Under 1 year" and "Under 5 year" in the slicer.  When you do so, you will only see the relevant Items.

[v-cherch-msft · Accepted solution]

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,

[Amir851]

Thank you for your help