Forum Discussion
Date between slicer - Change order
- 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 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
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 faster
- PowerBILeaner266 months agoRegular Visitor
Thanks Natarajan and thanks for the quick response.