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 a matrix table that I want to filter based on a date slicer on a set of customers. However, I have another field that if its null/blank I would like the filter to not touch regardless of the date on the filter.
For example
ID Val DateField
1 3 2007-01-01
2 2 2005-01-01
3 2 2001-01-01
4 1999-01-01
If I have a DateField slicer and I set it to 2004-12-31 I'd like the following results:
ID Val DateField
1 3 2007-01-01
2 2 2005-01-01
4 1999-01-01
ID1 is selected because the DateField is greater than the selected date
ID2 is selected because the DateField is greater than the selected date
ID4 is selected not because the datefield is greater but because the Val field is blank.
I'm basically requiring an OR statement on the slicer.
Any ideas?
Solved! Go to Solution.
Hi @Rich2852
You could create a date table, then edit relationship with your data table, next add the "date" column to a slicer
Table = CALENDARAUTO()
2. create a measure in your data table, then add this measure to the Visula level filter and set "show data when value equal: 1".
Measure = IF(MAX([DateField])>SELECTEDVALUE('Table'[Date])||MAX([Val])=BLANK(),1,0)
Best Regards
Maggie
Hi @Rich2852
You could create a date table, then edit relationship with your data table, next add the "date" column to a slicer
Table = CALENDARAUTO()
2. create a measure in your data table, then add this measure to the Visula level filter and set "show data when value equal: 1".
Measure = IF(MAX([DateField])>SELECTEDVALUE('Table'[Date])||MAX([Val])=BLANK(),1,0)
Best Regards
Maggie
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |