Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
78 | |
59 | |
51 |
User | Count |
---|---|
165 | |
83 | |
68 | |
68 | |
59 |