How to Remove "Next" Option from Relative Date Slicer?

[manoj_0911]

Hello,

I'm using the Relative Date Slicer in Power BI and would like to restrict users from selecting future dates (i.e., remove the "Next" option). Is there a way to disable or remove the "Next" option in the slicer so that only past and current periods can be selected?

If this isn't directly possible, are there any workarounds I can use to prevent users from selecting future dates?

Thank you in advance for your help!

Best regards,
Manoj Prabhakar

[rajendraongole1 · Accepted solution]

Hi @manoj_0911 -In Power BI, there's no direct way to disable or remove the "Next" option from the Relative Date Slicer.

Add a new column to your date table that checks whether a date is in the past or the current day and flags future dates.

IsFutureDate = IF(Dates[Date] > TODAY(), 1, 0)

In your report, apply a filter on the date slicer or table visual to exclude dates where IsFutureDate=1.

Add the Relative Date Slicer: You can now use the Relative Date Slicer, but the filter will automatically prevent future dates from being selected by users.

or You can apply page-level filters to restrict the available date range to only past and current dates Filter: Dates[Date] <= TODAY()

check the above alternative approaches suggested at page level filter and flag condition