Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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,...
Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    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]&"")

  • Greg_Deckler's avatar
    Greg_Deckler
    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. 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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