Forum Discussion
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
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.
Any and all help is greatly appreciated
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 showingYou 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
4 Replies
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 showingYou 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 HafizThank you. I wound up creating a calculated column using binary to determine previous day, which worked. I am still trying to figure out the weekend part. The trouble is I need both of them on the same page. The previous day filter how I did it works great- except until next Monday comes around and I need to show 3 days. Is there a way to default to the weekend but only if the current day is Monday else prev day?
I will take a lot at the link you provided.
I did not get what you want actually. Is that what you want, if today is monday, then it will show previous 3 days and if not monday then it will show previous day.
This is on / off situation. How do you implement such scenario. As far as I understand, that slicer default must always be on.
If this is your case, then 1 day in a week it will be 3 selected day, and all the other day it will be single selected.I don't think I am explaining it very well. I will try your solution you provided and remove what I did since it doesn't seem to be working anyway. Thanks again.
