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.
Hey guys,
I'm trying to use a slicer so that when I select a week (say week 50), the data in a graph shows everything for the last 12 weeks ending on week 50. I can't use the relative slicer function because I need the slicer to be in the select individual weeks format. Thanks
Solved! Go to Solution.
Hi @Anonymous,
Please check out the demo in the attachment.
1. Create a new date table. Because the dates will be filter out by the slicer which is from the same table.
2. Don't create any relationship with other table.
3. Modify the measure below.
Measure 2 = VAR minDate = FIRSTDATE ( DATESINPERIOD ( 'Table1'[Date], MAX ( 'Table1'[Date] ), -84, DAY ) ) RETURN IF ( MIN ( 'Table 2'[Date] ) < minDate || MIN ( 'Table 2'[Date] ) > MAX ( 'Table1'[Date] ), BLANK (), SUM ( 'Table 2'[Value] ) )
Best Regards,
Dale
Hi @Anonymous,
Please check out the demo in the attachment.
1. Create a new date table. Because the dates will be filter out by the slicer which is from the same table.
2. Don't create any relationship with other table.
3. Modify the measure below.
Measure 2 = VAR minDate = FIRSTDATE ( DATESINPERIOD ( 'Table1'[Date], MAX ( 'Table1'[Date] ), -84, DAY ) ) RETURN IF ( MIN ( 'Table 2'[Date] ) < minDate || MIN ( 'Table 2'[Date] ) > MAX ( 'Table1'[Date] ), BLANK (), SUM ( 'Table 2'[Value] ) )
Best Regards,
Dale
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |