Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
113 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |