Forum Discussion
default Slicer value
Hi guy's
i have date Slicer in UAT level, here i selected manually max value. after that if i published into Prod level i want selected automatically max date value on slicer.
regrads,
Navin_512
@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]&"")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.
3 Replies
@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]&"")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.
Hi Anonymous,
As Greg_Deckler and amitchandak said, current power bi slicers not provide the default selection value features.
You can refer to their tricks that share above to mark specific range dynamically and use bookmark to save these selections to quickly restore the sleicotn of your filters.
We can use a bookmark to save current filter effects of the specific report and use it to quickly restore selections; when you work on the service side, it allows the end-users to configure personal bookmarks to achieve default selection.
Create bookmarks in Power BI Desktop to share insights and build stories
Regards,
Xiaoxin Sheng