Forum Discussion
Short X axis.
Hi All,
i have x axis in a visual like this
and requirment is, It should be start from "< values" and end with ">values" arrange the x axis ascending order and the problem is this x axis string would change every day may be tommorrow it would be <40 or 2nd value may be start from (-36,-35).
how can i short x axis if user select a perticular date it would be change and short in a proper way.
Hi Anonymous
You can create an Index column for your data in ascending order .Then sort by the Index column in your visual and choose Sort ascending .
Original data and final result .
I have attached my pbix file , you can refer to it .
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- amitchandak
Super User
Anonymous , is x-axis value are not in sortable format ? You can keep x-axis sorted from three dots.
Or create a new column that can correct sort of x-axis
How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c Hi Anonymous
You can create an Index column for your data in ascending order .Then sort by the Index column in your visual and choose Sort ascending .
Original data and final result .
I have attached my pbix file , you can refer to it .
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
