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.