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

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
Yuka
Frequent Visitor

Sorting X-Axis (Customer Satisfaction scoring)

Hi all

 

I would need your help over here. 

 

I tried sorting the order of the customer satisfaction score (Very unsatisfied -> Very satisfied) using the three button options at the top right side of the graph, but to no avail. 

 

This is what it looks like

 

Yuka_0-1643429086920.png

 

I have also tried creating a new table (CSAT Weight) with the CSAT score and add an index column.

Yuka_1-1643429247106.png

 

 

I created a relationship between two tables (CSAT Weight and Sheet1) and tried configuring the axis. 

Yuka_2-1643429302020.png

 

Alas, it still produced the above first sorting order.

Is there a way to sort from  the following 'Very Unsatisfied', 'Unsatisfied', Neutral', 'Satisfied', 'Very Satisfied' order?

 

What am I missing over here?

 

Thank you!!

 

 

1 ACCEPTED SOLUTION
mussaenda
Super User
Super User

Hi @Yuka ,

 

You are on the right track. 

Good job on creating the index. 

 

Next step is selecting the CSAT column and sort it by index which you can on Column tools.

Once you did that, it will be arranged according to your index.

 

Hope this helps

View solution in original post

3 REPLIES 3
mussaenda
Super User
Super User

Hi @Yuka ,

 

You are on the right track. 

Good job on creating the index. 

 

Next step is selecting the CSAT column and sort it by index which you can on Column tools.

Once you did that, it will be arranged according to your index.

 

Hope this helps

Hi @mussaenda 

 

Really thanks for the tip! I realised that i have been clicking 'Sort column' by the 'Index' column instead of 'CSAT' column which is the reason why I could not get the sort order that I wanted.

22LACMT_0-1672856371497.png

How do I get passed the auto sort feature on the visual? 

 

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors
Top Kudoed Authors