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 se...
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

shafiz_p's avatar
shafiz_p
Super User
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