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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
b_minesh
Frequent Visitor

Arranging X Axis Categorical Values

I have some rating data that ranges between 0 to 5 and the following labels have been given to each number 

 

0 - Below Expectations

1 - Not Achieving

2 - Partially Achieving

3 - Achieving Expectations

4 - Exceeding Expectations

5 - Outstanding

 

Right now my graph is not in the correct order and looks like below -

x-axis.PNG

I need the output in the following manner - 

neededxaxis.png

 

******************************************************************************************************************************************

I have tried using the following sort options. 

sort.PNG

 

But it does not help as my categorical values are not in any particular order either from a to z or from z to a. 

 

Please help.

1 ACCEPTED SOLUTION
ryan_mayu
Super User
Super User

@b_minesh 

sory by the index column

1.PNG

2.PNG

you may refer to the doc below

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column





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

Proud to be a Super User!




View solution in original post

3 REPLIES 3
ryan_mayu
Super User
Super User

@b_minesh 

sory by the index column

1.PNG

2.PNG

you may refer to the doc below

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column





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

Proud to be a Super User!




ryan_mayu
Super User
Super User

@b_minesh 

you can create a new column with corresponding sequences as sort by the new column

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column

 

 





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

Proud to be a Super User!




Doing so arranges the x-axis from a to z in ascending order as shown in the image below. 

 

xsort.PNG

 

But the data should look like this 

 

neededxaxis.png

 

So as you can see the x-axis i need has no particular order from a to z or z to a. 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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