Forum Discussion
Bar chart including dates before the slicer date
Hello all! I need to build a bar chart, which marks the last data date of a date slicer, but I want it to show not only the date of that filtered day, but also data up to 21 days prior to that sl...
Hi Anonymous ,
Please have a try.
Create a calendar table and put the dates in the calendar table into the slicer.
Table 2 = CALENDAR(DATE(2022,1,1),DATE(2022,5,31))Then create measures.
measure_beforedate = VAR _sel = SELECTEDVALUE ( 'Table 2'[Date] ) RETURN IF ( MAX ( 'Table'[date] ) <= _sel, 1, 0 )Measure_values = SUMX ( FILTER ( ALL ( 'Table' ), 'Table'[date] <= SELECTEDVALUE ( 'Table 2'[Date] ) ), 'Table'[value] )Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello, dies this help you with your problem 😊? Anonymous
The Slicer is a BEFORE slicer.
The _MaxDateMinus21 returns 25-01-2020, so any date before that is not counted
Hello,
Thanks for your reply, but is not that I need. I need to make it with a dropdown slicer.
Thanks 🙂
Why is the dropdown slicer a must 🤔?
Design need 🙂