Forum Discussion

PowerBILeaner26's avatar
PowerBILeaner26
Regular Visitor
6 months ago
Solved

Date between slicer - Change order

Hello Powber BI Support,   How to change the order in "Date Between" slicer?   Default (from lower date to higher date)   01/01/2026         02/25/2026   But I am looking for (from higher dat...
  • v-echaithra's avatar
    v-echaithra
    5 months ago

    Hi PowerBILeaner26 ,

    Thank you for the response. 

    The reverse index approach works functionally, but you’re right, it doesn’t show the actual date range to the user.

    A common workaround is to keep the reverse index slicer and add a dynamic measure to display the selected date range in a Card visual.

    1. Create measures

    Selected Start Date =
    CALCULATE(
    MAX('Date'[Date]),
    FILTER(ALL('Date'),
    'Date'[ReverseIndex] = MIN('Date'[ReverseIndex])
    ))


    Selected End Date =
    CALCULATE(
    MIN('Date'[Date]),
    FILTER(ALL('Date'),
    'Date'[ReverseIndex] = MAX('Date'[ReverseIndex])
    ))

     

    2. Create display measure

    Selected Date Range =
    "From: " & FORMAT([Selected Start Date], "dd MMM yyyy") &
    " To: " & FORMAT([Selected End Date], "dd MMM yyyy")

    3. Add to report

    Keep using ReverseIndex slicer
    Add a Card visual
    Use Selected Date Range

    This way users can still control the slider (latest to oldest) while clearly seeing:

    “From: [Start Date]  To: [End Date]”

    Hope this helps.

    Thank you