Forum Discussion

vafowler's avatar
vafowler
New Member
2 years ago
Solved

Date defaults

Good Morning,

 

I want to set a default date for my dashboard. I also want to create a weekend button or slicer if possible. The dashboard this will be used on refreshes daily.Here is my current set up. When I refresh the data tomorrow and subscribers open the report it will still be defaulted to this. What can I do to have it automatically default to the previous day? 

 

The second part of my question involves a weekend filter. On Monday, I want the default to show the previous 3 days (Friday, Saturday, and Sunday). 

 Below is my current Calendar Table script

Calendar =
VAR CalTable = CALENDAR(DATE(2023,1,1), DATE(2024, 12, 31))
VAR MyCal =
    ADDCOLUMNS(
        CalTable,
        "Index", MONTH([Date]),
        "Month", FORMAT([Date], "mmm"),
        "Year", FORMAT([Date], "yyyy"),
        "Week", WEEKNUM([Date], 2),
        "DayName", FORMAT([Date], "ddd"),
        "Day", FORMAT([Date], "d"),
        "DayNo", WEEKDAY([Date], 2)
    )
    RETURN
        MyCal

I have tried looking at previous answers but none of them work for me. An example of a previous is the link below. I am unable to use the Date Picker. As for the other defauly options under General, I don't have those as options. 

https://community.fabric.microsoft.com/t5/Desktop/How-to-set-default-MAX-date-in-Slicer/m-p/3430227#M1138287

 

Any and all help is greatly appreciated

Need Help
  • shafiz_p's avatar
    shafiz_p
    2 years ago

    Hi vafowler  If you want your dashboard automatically default to previous day, you can check my earlier solution here:

    Select Slicer default yesterday with all dates showing 

     

    You can use the same concept to tag the previous 3 days for your second part solution. Only changes would be, instead of single select it would be multiselect. Select previous 3 days using control button.

    M code to identify Yesterday, Day before Last, or whatever you want, use the below code in power query.

    Custom date =
    if [Date] = Date.From(Date.AddDays(DateTime.LocalNow(), -1)) then "Yesterday" else if [Date] = Date.From(Date.AddDays(DateTime.LocalNow(), -3)) then "Day Before Last" else [Date]

     

     

    Hope this helps!!

    If this solved your problem, please accept it as a solution, and a thumps up!!

    Best Regards,
    Shahariar Hafiz