Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have a report with slicers for Month, Day etc...
How can I default the values to Today, i.e. 12/07/2016?
Thanks,
S
I assume this is all taking place in a standard date table? Make a calculated column to use as a slicer.
Selected Day = IF(DateTable[Date] = TODAY(), "Today", FORMAT(DateTable[Date], "dd/MM/YYYY"))
Add that column as a slicer on your report, select Today on the slicer and save.
Proud to be a Super User!
Hi,
It could be Quarter, i.e. Q3, Week, i.e. 15, Day, i.e. 7 etc...
Thanks!
I don't understand what you're asking for. Do you not want a slicer that allows you to select single days that defaults to today's date?
Proud to be a Super User!
What I usually do is create a new calc column in the date table that does something like this:
Column = IF([Date] = TODAY(), "Y", "N")
then you can use this a slicer.
Now schedule refresh every night, the column will then automatically updated to the new day on nightly basis.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |