Forum Discussion
Ordering in visual
- 3 years ago
Hi ashutoshbafna ,
You can create custom order in Power query. Please follow steps below.
1. Go to Query Editor
2. Go to Add column then Click Extract and Select Text Before Delimeter
3. Type : (colon) as delimiter. Hit OK
4. You'll have this column. Just change type to whole number.
5. Close and apply. Go back to Report view
6. In Fields Pane, Select your variable for the x-axis and then go to column tools. Click Sort by column and then select Text Before Delimiter.
7. Click 3 dots in your visual and then Sort axis and sort ascending
Let me know if it works 😉
Hi
Click on the three dots bellow, then click on "Sort Axis" and select the field you want to sort to
Kind regards,
José
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂
Hi, by sorting that way sequence i am getting as 1,10,11,12,2 ; i want as 1,2,3,4