Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I have a regular date silcer with single select enabled and date table but the client is asking for it to defualt to yesterday as the report is refeshed daily with yesterdays data. They don't want to use the relative option becuase it's not viewable as a calendar.
Any assistance would be appreaicated, Is there a way to do this?
Thanks
Solved! Go to Solution.
@ringovski , Power Bi do not support any funtion for that.
You need to create a column with yesterdat value and use that
example - This has date along with with yesterday, today
Date Type =
SWITCH(TRUE(),
'Date'[Date] = TODAY(), "Today",
'Date'[Date] = TODAY() -1 , "Yesterday",
'Date'[Date] = TODAY() +1 , "Tomorrow",
[Date]& "")
You can save this on yesterday . also you can sort this on date column
Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA
@ringovski , Power Bi do not support any funtion for that.
You need to create a column with yesterdat value and use that
example - This has date along with with yesterday, today
Date Type =
SWITCH(TRUE(),
'Date'[Date] = TODAY(), "Today",
'Date'[Date] = TODAY() -1 , "Yesterday",
'Date'[Date] = TODAY() +1 , "Tomorrow",
[Date]& "")
You can save this on yesterday . also you can sort this on date column
Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
45 | |
26 | |
21 | |
12 | |
8 |
User | Count |
---|---|
74 | |
52 | |
45 | |
15 | |
12 |