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...
Need Help
  • 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

cengizhanarslan's avatar
cengizhanarslan
Super User
6 months ago

The Between date slicer always shows the earlier date on the left and the later date on the right. Unfortunately, this order cannot be reversed, it’s fixed by design in Power BI.

PowerBILeaner26's avatar
PowerBILeaner26
Regular Visitor
6 months ago

Thanks cengizhanarslan and thanks for the quick response. 

 

Is there any slider control to control 2 to 3 line charts when using the slider control (from left to right)?

  • Natarajan_M's avatar
    Natarajan_M
    Super User
    6 months ago

    Hi PowerBILeaner26 , Can you please explain the scenario with an example ?

    • PowerBILeaner26's avatar
      PowerBILeaner26
      Regular Visitor
      6 months ago

      Here is the example. 

       

      The both chart should move from left to right when we move the slider (right now using Date between slider) and this will work when the date from minimum to maximum but the chart is displaying the higher date in the beginning. 

       

      A question: Is there any slider control (without date) so that it will move from higher date to lower date on the charts. 

       

       

      • Natarajan_M's avatar
        Natarajan_M
        Super User
        6 months ago

        Hi PowerBILeaner26 , 

        If we set the Slicer option to "After," this will closely match your requirements. This setting will fix the maximum date in the date dimension, allowing you to control the slider and adjust the starting value.





        Thanks 
        If this response was helpful in any way, I’d gladly accept a kudo.
        Please mark it as the correct solution. It helps other community members find their way faster