Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

How to Sort Month Year Column. (Text Format)

I have a data I want to Sort Month in Order. In Slicer when selecting any thing other than Current Exception month need to be sorted. Please help. Thanks in Advance.    
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , You need to have a sort column for that. You have a handle based on time

 

Format(datevalues([Dynamic X axis] &"-2022"), "mmdd" )

 

Add additional conditional for other and mark this as sort column https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

 

But my advice would be to explore field parameters for dynamic Axis, Above seem like old method 

https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9afd

 

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c