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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ashutoshbafna
Regular Visitor

Ordering in visual

ashutoshbafna_0-1665753728743.png

I want sequence as 1,2,3,....10,11,12. 

1 ACCEPTED SOLUTION
Newbie22
Resolver I
Resolver I

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

Newbie22_1-1665755943744.png

 

3. Type : (colon) as delimiter. Hit OK

Newbie22_2-1665755970755.png

 

4. You'll have this column. Just change type to whole number.

 

Newbie22_3-1665756001304.png

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.

 

Newbie22_4-1665756113379.png

7. Click 3 dots in your visual and then Sort axis and sort ascending

 

Newbie22_0-1665756269771.png

 

 

Let me know if it works 😉

 

 

 

 

View solution in original post

5 REPLIES 5
Arul
Super User
Super User

@ashutoshbafna ,

try this,

Step 1: In power query editor click the above column (field used in the Y-axis) use Extract and then Text Before Delimiter. Now you have new column.

Arul_0-1665756155814.png

 


Step 2: Rename the new column from Text Before Delimiter to "New name".
Step 3: Change the datatype of new column from text to whole number.Then, close and apply.
Step 4: Now go to the data view in desktop and click the above column used in Y-Axis and the sort this column based on the newly extracted column. You will get see expected the result in your visual.
refer the attached image,

Arul_3-1665756254514.png

 

Arul_1-1665756196888.pngArul_2-1665756230300.png

Thanks,

 

 

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


LinkedIn


Newbie22
Resolver I
Resolver I

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

Newbie22_1-1665755943744.png

 

3. Type : (colon) as delimiter. Hit OK

Newbie22_2-1665755970755.png

 

4. You'll have this column. Just change type to whole number.

 

Newbie22_3-1665756001304.png

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.

 

Newbie22_4-1665756113379.png

7. Click 3 dots in your visual and then Sort axis and sort ascending

 

Newbie22_0-1665756269771.png

 

 

Let me know if it works 😉

 

 

 

 

https://drive.google.com/file/d/1D5gD_6tAsH3KU8fyKulXjd-TYqXAXg2h/view?usp=sharing I tried all steps , still same thing happened , i have attached file for your reference , i want domain 1, then 2 and so on till last domain 12. But it did not worked 

jcalheir
Solution Supplier
Solution Supplier

Hi

 

Click on the three dots bellow, then click on "Sort Axis" and select the field you want to sort to

 

jcalheir_0-1665755150397.png

 

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 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.