Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Folks,
I have used date slicer with a date range as followed:
This is working properly.
Now i want to show end date as todays date but keeping the date range intact as above.
How to modify for the same?
Thanks in advance.
Pranesh M Juwale
You may simply add a calculated table.
Table = CALENDAR ( DATE ( 2018, 1, 1 ), TODAY () )
Hi Sam,
thanks for the update.
Table = CALENDAR ( DATE ( 2018, 1, 1 ), TODAY () )
But this will give me a slicer as today with end oo the date range, I don't want that.
I want the slicer to have end date parameter in the visual as today and the slicer can be moved manually ahead of the todays date till the end of the date range.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |