Relative Date Slicer showing default "Last 1 Days" instead of "Last 1 select"

[0803]

Hello community, 

I have a Date table that I have used as a relative date slicer on the visuals. However, I noted that the relative date slicer is showing "Last 1 Days" by default instead of the usual "Last 1 Select". I suspect that it could be the date table that is triggering this change which I do not want. I would prefer to leave the relative date slicer as "Last 1 Select". 

Below is the image of the Last 1 Days. 

When I click on "clear filter selection" the days goes away. However, it returns when I click on other tabs on the dashboard. 

This is currently my date table: 

DateTable =

ADDCOLUMNS (

    CALENDAR (DATE(2024, 1, 1), TODAY()),

    "Year", YEAR([Date]),

    "Month", FORMAT([Date], "MMMM"),

    "MonthNumber", MONTH([Date]),

    "YearMonth", FORMAT([Date], "YYYY-MM")

)

Appreciate any help.

Thank you

[tayloramy · Accepted solution]

Hi @0803, 

The relative date slicer always needs a unit (Days/Weeks/Months/Years). If you leave it unset, Power BI will resolve it to a real unit (most commonly Days). That behavior isn’t coming from your Date table; it’s the slicer’s state plus features like persistent filters, bookmarks, or sync slicers. In other words, “Last 1 Select” is just a placeholder - it won’t stay blank once the report state is saved or remembered.

Quick solution

1. Pick the default you actually want and save it
   In Desktop, set the slicer the way you want users to land (e.g., switch the unit to Months or clear it with a Between slicer if you prefer no default), then Save and Publish. The open state of the report is what you save. Docs: Bookmarks (capture default states) and Docs: Relative date slicer.
2. Stop the service from “remembering” a prior unit (Days)
   In the report’s settings, disable persistent filters if you don’t want the service to restore each reader’s last slicer state: File > Options and settings > Options > Current File > Report settings > check “Don’t allow end users to save filters on this file in the Power BI service,” then republish. Docs: Format filters & persistent filters and Docs: Report settings.
3. Check Sync Slicers across pages
   If your date slicer is synced, switching tabs will reapply the synced selection (e.g., “Last 1 Days”). Open View > Sync slicers and either unsync it or deliberately set the default and keep it synced. Docs: Sync slicers.
4. Optional: Use a “Between” date slicer if you truly want no unit by default
   A Between slicer starts blank and avoids the “Days” default entirely. The relative slicer, by design, will always have a unit. Docs: Date slicer modes.

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

[tayloramy · Accepted solution]

Hi @0803, 

The relative date slicer always needs a unit (Days/Weeks/Months/Years). If you leave it unset, Power BI will resolve it to a real unit (most commonly Days). That behavior isn’t coming from your Date table; it’s the slicer’s state plus features like persistent filters, bookmarks, or sync slicers. In other words, “Last 1 Select” is just a placeholder - it won’t stay blank once the report state is saved or remembered.

Quick solution

1. Pick the default you actually want and save it
   In Desktop, set the slicer the way you want users to land (e.g., switch the unit to Months or clear it with a Between slicer if you prefer no default), then Save and Publish. The open state of the report is what you save. Docs: Bookmarks (capture default states) and Docs: Relative date slicer.
2. Stop the service from “remembering” a prior unit (Days)
   In the report’s settings, disable persistent filters if you don’t want the service to restore each reader’s last slicer state: File > Options and settings > Options > Current File > Report settings > check “Don’t allow end users to save filters on this file in the Power BI service,” then republish. Docs: Format filters & persistent filters and Docs: Report settings.
3. Check Sync Slicers across pages
   If your date slicer is synced, switching tabs will reapply the synced selection (e.g., “Last 1 Days”). Open View > Sync slicers and either unsync it or deliberately set the default and keep it synced. Docs: Sync slicers.
4. Optional: Use a “Between” date slicer if you truly want no unit by default
   A Between slicer starts blank and avoids the “Days” default entirely. The relative slicer, by design, will always have a unit. Docs: Date slicer modes.

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

[0803 · Accepted solution]

I understand now. I will leave the relative date slicer as is after understanding that Power BI will resolve to find a real unit (days) for it. 

Thank you