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

Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.

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
PBIApril_Carousel

Power BI Monthly Update - April 2025

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

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

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