Forum Discussion
Amir851
7 years agoHelper I
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...
- 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,
v-cherch-msft
7 years agoMicrosoft 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 )
)
)
)
)
Regards,
Amir851
7 years agoHelper I
Thank you for your help