Automatic update of a date to today's date

[some_analyst]

I have a simple chart uploaded to PBI Service and I have a daily subscription going to some people of this chart. 

I have a slicer there with dates - e.g. 28/4 - Sunday;  29/4 - Monday;  Today.

When the date refreshes, how do I make sure that there is always 'today' selected. At this point the slicer is left to what i last selected and does not change to the following date: 

[Ritaf1983]

Hi @some_analyst 

You’ve already implemented the right filtering logic behind the scenes (e.g. using a calculated column or dynamic label to highlight “Today”), as shown in your screenshot. What remains is to publish the report with “Today” selected in the slicer, and make sure users cannot override that selection.

To do this:

1. In Power BI Desktop, make sure the “Today” value is selected in your slicer before publishing.

2. In the Power BI Service, after publishing:

   • Open the report.

   • Select the “File” menu → Report settings.

   • Under "Persistent filters", disable the option:
     “Allow end users to save filters on this report”.

This ensures the report always opens with the original “Today” selection and ignores any filters changed by users or during previous sessions.

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

[some_analyst]

Thanks @Ritaf1983 , I am pretty sure that it is what I did, except the persistent filters.

The calculated column I have is this:

Formatted Date Full =

VAR SelectedDate = dim_date[PK_date]

RETURN

IF(

    SelectedDate = TODAY(),

    "Today",

    CONCATENATE(

        CONCATENATE(dim_date[Day Name], ", "),

        FORMAT(SelectedDate, "dd/mm/yyyy")

    )

)

And I am not getting the updated date.

I will set the filters and see tomorrow

[Ritaf1983 · Accepted solution]

Hi @some_analyst  The formula looks fine, especially if the filtering functionality is working as expected.
From what I understood, the challenge was to preserve the "Today" selection.
The solution for that is to publish the report with the desired selection and disable the option for users to save filters.
This will kee the "Today" as a default selection

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