Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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
Solved! Go to 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,
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.
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,
Thank you for your help
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |