Forum Discussion
default Slicer value
- 6 years ago
@Navin512 , Create a column like this in the date table and use it by default (Today or Last Date
Tipo de fecha: SWITCH(TRUE(),'Date'[Date]-TODAY(),"Today"
,'Date'[Fecha]-TODAY()-1,"Yesterday"
,'Date'[Fecha]&"")Tipo de fecha: SWITCH(TRUE(),'Date'[Date]-maxx(sales,sales[date]),"Last Date"
,'Date'[Fecha]&"") - 6 years ago
Anonymous So, unfortunately this is a very common and yet kind of unsolved problem. There are work-a-rounds however. One is to use the Relative Date Slicer. Another is to create a column like this:
DateSlicer Column = VAR __Max = MAX('Table'[Date]) RETURN IF([Date]=__Max,"Latest",[Date]&"")Then you can set your slicer to Latest.
@Navin512 , Create a column like this in the date table and use it by default (Today or Last Date
Tipo de fecha: SWITCH(TRUE(),'Date'[Date]-TODAY(),"Today"
,'Date'[Fecha]-TODAY()-1,"Yesterday"
,'Date'[Fecha]&"")
Tipo de fecha: SWITCH(TRUE(),'Date'[Date]-maxx(sales,sales[date]),"Last Date"
,'Date'[Fecha]&"")