Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I want to show the latest dates as default in my slicer with all the previous dates,
Please let me know if there is a way to do it.
Solved! Go to Solution.
Hi, @Anonymous
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
Table:
You may create a calculated column as below to have an option to show last 3 days.
Previous Days =
IF(
[Date]>=TODAY()-2&&
[Date]<=TODAY(),
"Last 3 Days",
IF(
[Date]<TODAY()-2,
[Date]&""
)
)
Today is 9/24/2020. Here is the result.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
i'm using the following formula
Date Type = SWITCH(TRUE(),'Date'[Date]=max(Table[Date]) ,"Latest Date"
,'Date'[Date]=TODAY()-1,"Yesterday"
,'Date'[Date]&"")
Which only gives me the current date. It removes all the other dates from being able to be selected. How do i get current date AND all the other available dates?
Hi, @Anonymous
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
Table:
You may create a calculated column as below to have an option to show last 3 days.
Previous Days =
IF(
[Date]>=TODAY()-2&&
[Date]<=TODAY(),
"Last 3 Days",
IF(
[Date]<TODAY()-2,
[Date]&""
)
)
Today is 9/24/2020. Here is the result.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , Create a column in date table like this
Date Type = SWITCH(TRUE(),'Date'[Date]=TODAY(),"Today"
,'Date'[Date]=TODAY()-1,"Yesterday"
,'Date'[Date]&"")
or
Date Type = SWITCH(TRUE(),'Date'[Date]=TODAY(),"Today"
,'Date'[Date]&"")
or
Date Type = SWITCH(TRUE(),'Date'[Date]=max(Table[Date]) ,"Latest Date"
,'Date'[Date]=TODAY()-1,"Yesterday"
,'Date'[Date]&"")
sort this on date column and use this one as filter
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |