default Slicer value

[Anonymous]

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

[amitchandak · Accepted solution]

@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]&"")

[v-shex-msft]

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 

What are bookmarks? 

Regards,

Xiaoxin Sheng

[Greg_Deckler · Accepted solution]

@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. 

[amitchandak · Accepted solution]

@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]&"")