Selecting Todays Date always in Slider with Before

[srlabhe]

Hi PBI Gurus

I have a slider where I select End Date with Slicer Settings as Before, so that it shows data before the same date.

Now I want this End Date to show always today's date as underlined query runs for Current Date i.e. Today.

Thanks in advance

[v-venuppu]

Hi @srlabhe ,

I wanted to check if you had a chance to raise a Ideas ticket..?Please consider sharing the idea you raised here, so others experiencing the same issue can upvote it. This will help prioritize it for development as soon as possible.

Thank you.

[v-venuppu]

Hi @srlabhe ,

May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.

Thank you.

[srlabhe]

No not yet, when I apply filter as 1 and publish , its still shows me last selected date than latest date

[MasonMA]

HI @srlabhe 

Please consider voting as a new feature for Power BI:)

https://community.fabric.microsoft.com/t5/Fabric-Ideas/idb-p/fbc_ideas

[v-venuppu]

Hi @srlabhe ,

I wanted to check if you had the opportunity to review the information provided and resolve the issue..?Please let us know if you need any further assistance.We are happy to help.

Thank you.

[v-venuppu]

Hi @srlabhe ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @MasonMA for the prompt response.

Slicers in Power BI don’t dynamically update to today’s date on refresh - they retain the last selected value. To achieve dynamic filtering for today, consider using a DAX measure with TODAY() or a disconnected table as a parameter to simulate the date selection. You can also display today’s date using a card and use it to drive logic in your visuals.

Thank you.

[MasonMA]

@srlabhe 

Hi there, one of the solutions is you can create one column in your 'Date' table with below DAX

IsBeforeToday = IF(Date_MasterTable[Date] <= TODAY(), 1, 0)

and then use the value in this column as a visual-level filter to restrict your date end value in slicer like below. 

Hope it helps:) 

[srlabhe]

Would this will show by default todays date in report when we refresh? I am not seeing the same

[MasonMA]

Well, this restricts your date range in Slicer up to Today. 

If you insist on using a “Before” slicer, the slicer itself will remember the last selected date, not update to today automatically.

[srlabhe]

Agree , but I need report to refresh everyday in morning selecting Todays date 

[MasonMA]

Hey, you may test the solution someone provided in this post before. I haven't got a chance to test it and no guarantee it works 100% in your requirements.

https://community.fabric.microsoft.com/t5/Report-Server/Power-BI-Slicer-Between-Dates-don-t-get-the-...

[srlabhe]

Its not working either way for me , the second alternative is partially working, but when I select Latest and apply filter on slicer , it works fine. But when data refreshes with more date, it doesnt switch to latest date