Forum Discussion
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 date to lower date)
02/25/2026 01/01/2026
I tried with DateSort = RANKX(ALL(TableName),[DateColumn],,DESC,DENSE) and NOT working when "Between" slider settings.
But it's working for when select either "Veritical list" or "Dropdopwn list" from slider settings.
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 RangeThis way users can still control the slider (latest to oldest) while clearly seeing:
“From: [Start Date] To: [End Date]”
Hope this helps.Thank you
14 Replies
- Natarajan_M
Super User
Hi PowerBILeaner26 ,
The slicer with the "between" option in Power BI is currently configured to display values in the order of minimum and maximum; this default behavior cannot be changed.
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 fasterThanks Natarajan and thanks for the quick response.
- cengizhanarslan
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.
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
Hi PowerBILeaner26 , Can you please explain the scenario with an example ?
v-echaithraCommunity Support
Hi PowerBILeaner26 ,
The Between date slicer direction cannot be reversed in Power BI. Sorting or ranking columns does not change the slider order. You can try this workaround to simulate a reverse (latest to oldest) slider in Power BI. The trick is to not use a Date slicer at all, but instead use a numeric index that represents dates in reverse order.
1) Create Reverse Index Column
For example:
latest date = smallest indexReverseIndex = RANKX(
ALL('Date'[Date]),
'Date'[Date],,
DESC,
DENSE)Date - ReverseIndex
25 Feb - 1
24 Feb - 2
23 Feb - 32) Create a slider using ReverseIndex
3)Create a Measure to Filter Dates:
Selected Date Range =
VAR MinIndex =
MIN('Date'[ReverseIndex])
VAR MaxIndex =
MAX('Date'[ReverseIndex])
RETURN
IF(
SELECTEDVALUE('Date'[ReverseIndex]) >= MinIndex &&
SELECTEDVALUE('Date'[ReverseIndex]) <= MaxIndex,
1)4) Apply Visual Filter
Add this measure to each chart.
Visual filter > Selected Date Range = 1Power BI cannot reverse the Date range slicer, but it can reverse numeric indexes. By mapping dates to numbers, you gain control over the slider direction.
Hope this helps.
Thank you.Hello v-echaithra,
Thank you for the workaround steps and it's working with the reverse index number.
But the end user looking with the date information in the slider so that either the end user can drag left to right (or) enter the date (start or end) to achieve the date range. The reverse index is working good but not sure about what date range selected.
Anyway thanks for the help. Much appreciated! For now, I will go with reverse index slider. Thank you!
- v-echaithra
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 RangeThis way users can still control the slider (latest to oldest) while clearly seeing:
“From: [Start Date] To: [End Date]”
Hope this helps.Thank you
- v-echaithra
Hi PowerBILeaner26,
We’d like to follow up regarding the recent concern. Kindly confirm whether the issue has been resolved, or if further assistance is still required. We are available to support you and are committed to helping you reach a resolution.
Thank you. - v-echaithra
Hi PowerBILeaner26 ,
May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.
Thank you.
