To show recent date in the Slicer as drop down prompt for users in PowerBI

[Anonymous]

Hi,

Kindly help me to acheive this scenario,

I have report requirement to show the order_date with the recent date in the datasource must be displayed first in the SLICER as Dropdown list prompt and also the report should runs for default date as the recent date.

Expected Output:

1. Recent date (ie.order date) should be displayed in the slicer as a drop down list prompt.

2. By default the report executes for the recent date in the datasource.

Order date should be in Slicer with dropdown list and also need to show the recent date first

Thanks,

Smanicka

[bomman]

 According to @Lise: "There is no option to set default value for a Slicer currently. You can vote the idea here"

Todor

[Anonymous]

Thank you!!

Is there any other way to run the report for the current_date initailly??

Thanks,

Smanicka

[v-ljerr-msft · Accepted solution]

Hi @Anonymous,

---

Is there any other way to run the report for the current_date initially??

---

If I understand you correctly, you should be able to follow steps below to show your report initially filtered by the most recent date. 

1. Add a calculate column to indicate if the date is the most recent in your table. The formula below is for your reference.

Is Most Recent Date = IF('Table1'[Order Date]=MAX('Table1'[Order Date]),1,0)

2. Then use the new added calculate column as Slicer on your report, and select value 1 for the Slicer.

3. Save your report. 

Regards