Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Amir851
Helper I
Helper I

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
v-cherch-msft
Employee
Employee

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.

View solution in original post

3 REPLIES 3
Ashish_Mathur
Super User
Super User

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
v-cherch-msft
Employee
Employee

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.

Thank you for your help

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.