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.

ItemsCertificateLast DateTodayDays DiffTimeline
Item1Certificate 127 Oct 201901 Apr 2019209 Under 1 Year
Item2Certificate 223 Mar 202001 Apr 2019357 Under 1 Year
Item3Certificate 323 Mar 202001 Apr 2019357 Under 1 Year
Item4Certificate 412 Apr 201901 Apr 201911 Under 1 Year
Item5Certificate 517 Jul 201901 Apr 2019107 Under 1 Year
Item6Certificate 617 Jul 201901 Apr 2019107 Under 1 Year
Item7Certificate 730 Sep 201901 Apr 2019182 Under 1 Year
Item8Certificate 809 Dec 201901 Apr 2019252 Under 1 Year
Item9Certificate 1401 Oct 202301 Apr 2019900 Under 5 Year
Item10Certificate 1003 Aug 201901 Apr 2019124 Under 1 Year
Item11Certificate 1401 Oct 202301 Apr 2019900 Under 5 Year
Item12Certificate 1211 Nov 201901 Apr 2019224 Under 1 Year
Item13Certificate 1319 Jun 201901 Apr 201979 Under 1 Year
Item14Certificate 1401 Oct 202301 Apr 2019900 Under 5 Year
Item15Certificate 1519 Jun 201901 Apr 201979 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 

Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    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,

3 Replies

  • v-cherch-msft's avatar
    v-cherch-msft
    Microsoft Employee
    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,

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    7 years ago

    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.