Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Khedr_Kanaan
Frequent Visitor

How to Dynamically Select the Most Recent Date in a Slicer?

Hello everyone,

I'm currently using Power BI Desktop and working with various data tables. Among these, there's a table with a "Date" column that I using as a slicer to filter other visuals and data, as shown in the attached screenshot.

Upon publishing the report to Power BI Service and conducting daily checks to validate the data, I've noticed that the Date slicer retains the last selected value. However, my goal is for it to dynamically update to the most recent date available within the slicer. For instance, as shown in the screenshot, the latest date is 21.02.2024. I expect that by tomorrow, the slicer should automatically update to 22.02.2024.

Khedr_Kanaan_0-1708595014485.png

I've tried to apply filters to the slicer and did some research for a solution, but all the information I found relates to handling dates in a standalone table, not as a column among other data.

I would greatly appreciate any assistance in resolving this issue. Thank you in advance.

2 REPLIES 2
v-jialongy-msft
Community Support
Community Support

Hi @Khedr_Kanaan 

 

Try the following step:

Select the slicer, and in the Format pane, under Visual > Slicer settings > Options, change the Style to Relative Date.

vjialongymsft_0-1708652577905.png

 

 

 

Best Regards,

Jayleny

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you very much for your response. It serves as a good alternative, but the issue is that the individuals I'm designing this for are used to using the 'Between' date slicer.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.