cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Amir851 Frequent Visitor
Frequent Visitor

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 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Need Help in Slicer selection

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 )
            )
        )
    )
)

1.png

Regards,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Community Support Team
Community Support Team

Re: Need Help in Slicer selection

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 )
            )
        )
    )
)

1.png

Regards,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super User
Super User

Re: Need Help in Slicer selection

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.

Amir851 Frequent Visitor
Frequent Visitor

Re: Need Help in Slicer selection

Thank you for your help