Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |