Forum Discussion

ashutoshbafna's avatar
ashutoshbafna
Regular Visitor
3 years ago
Solved

Ordering in visual

I want sequence as 1,2,3,....10,11,12. 
  • Newbie22's avatar
    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 ðŸ˜‰