Automatically select the latest date in slicer (automated preselected slicer)

[Anonymous]

Hello,

I have multiple reports in which new data extract is added each month. I am currently choosing the latest extract date in the extract date slicer so I can see only the last extract data. However, due to I have many reports, it is time consuming to go to each report, go edit mode select the last date in extract date slicer and save the report. There is also the fact of human error to miss a report with the old extract date preselected.

Is there any way or a workaround that can sort this automatically? i.e. every time a new data extract is added the report to show the latest date extract data.

I am thinking, there may be a way with DAX or any other work around.

Many thanks!

[Thejeswar · Accepted solution]

Hi @Anonymous ,

The Below video shows a way to get the latest date always by storing it to text and it is always selected. Do check if it helps in your case

https://www.youtube.com/watch?v=c_MjL1Cngbs 

Regards,

[PatChan]

Hi, 

I had the same requirement. In my case, I added the date field to the slicer, change filter type to "Relative Date" and choose "is in the last 1 year" and check "today" box. This ensures the latest dates are automatically selected without user having to manually drag to include the new dates.

[webchris]

Hi,

could you meanwhile find a way which works in the way you want it to work?

The offered solutions limit the user's possibility to select other dates, which is my problem, too. So I would be interested in a "real" solution...

Thanks,

Christian

[Thejeswar · Accepted solution]

Hi @Anonymous ,

The Below video shows a way to get the latest date always by storing it to text and it is always selected. Do check if it helps in your case

https://www.youtube.com/watch?v=c_MjL1Cngbs 

Regards,

[Anonymous · Accepted solution]

Many thanks this actually works!

I also found another source that solves the issue with a similar way. 

powerbi - Default slicer selection (latest date) in Power BI - Stack Overflow

[Anonymous]

Many thanks for the response Pat. I forgot to mention that the users should still be able to select previous months. I believe with the solution you mentioned. Users will not be able to do this due to the IsLatestMonth filter.

[mahoneypat]

I would add a Date table to your model (that automatically expands when new data are added) and either use a relative time filter on the reports, or add a column to your date table with IsLatestMonth (and filter your pages to where IsLatestMonth = "Y".

Pat