Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
saif
Frequent Visitor

Change order of dates in Date Slicer

Hi,

 

I need to change the date order shown in date slicer as shown below:

 

Current State:

saif_0-1595228310155.png

Expected State:

saif_1-1595228392945.png

So I want the Max date to come first and want to use the slicer from left to right to select date ranges between Max date and Min date.

 

1 ACCEPTED SOLUTION
v-easonf-msft
Community Support
Community Support

Hi , @saif 

Unfortunately, I'm afraid it couldn't achieve in Power BI for now after my research.

For your requirement , you can come up with a new idea and add your comments there to make this feature coming sooner. https://ideas.powerbi.com/forums/265200-power-bi-ideas

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-easonf-msft
Community Support
Community Support

Hi , @saif 

Unfortunately, I'm afraid it couldn't achieve in Power BI for now after my research.

For your requirement , you can come up with a new idea and add your comments there to make this feature coming sooner. https://ideas.powerbi.com/forums/265200-power-bi-ideas

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak
Super User
Super User

@saif , I doubt that is possible.

 

But Try this

 

New Date =  [date]

New Rank =  rankx(all(Table),[Date],,desc,dense)

 

Sort new date on new rank and try.

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.