cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cuongle Member
Member

How to choose default value for slicer on Date column

How to choose the default date on slicer as the latest report date as below image, so when the end user visits the dashboard they always see the data for latest report date.

 

 

Date Slicer.PNG

4 REPLIES 4
Super User IV
Super User IV

Re: How to choose default value for slicer on Date column

I do not know of a way to set a default value like that with a slicer. You can set the slicer and save the report and that selection will stay, but not like what you are referring to. Only thing you could do would be to create an IsToday column and set a page or report filter but that's also not what you are looking for.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

cuongle Member
Member

Re: How to choose default value for slicer on Date column

Thanks @Greg_Deckler for the idea, but this is not what I am looking for and also the report date is not actually today.

 

Is there any other altenative visual to represent the date filter?

Microsoft v-yulgu-msft
Microsoft

Re: How to choose default value for slicer on Date column

Hi @cuongle,

 

There is no option to set default value for a Slicer currently. Some ideas about the issue have been submitted to Power BI team, you can vote this issue in the following link.

 

Default Selected Slicer or Tile-By Value Configuration

 

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
cuongle Member
Member

Re: How to choose default value for slicer on Date column

Now, it's over one year, do we have any decent way for this problem?

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors