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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
nishchaya
New Member

How to Sort Axis for Vizusalisations?

  1. Hover over a numerical axis to bring up the sort icon.
  2. Click the icon to sort.

Sort Ascending or Descending:Click on the column header and use the sorting icons to sort the data in ascending or descending order. Sort by Column Using the Ribbon:In the "Data" view, select the column, and you can use the "Sort Ascending" or "Sort Descending" buttons in the ribbon.

1 ACCEPTED SOLUTION
HarishKM
Memorable Member
Memorable Member

@nishchaya Hey,
1st way - You can add a conditional column in Power query based on specific column and go data view sort it by a column like this.

 

HarishKM_0-1712902998676.png

 

or you can create a  disconnected table using enter data or using dax . Create a relationship in between both table and use related dax function to get value based on specific column. like this

 

HarishKM_1-1712903224364.png

 

Then you can select a specific column (In my case country) then sort it by country sort to get desired result.

 

 

Thanks

Harish 

Did I answer your question? Kindly give kudos and Mark my post as a solution!

View solution in original post

1 REPLY 1
HarishKM
Memorable Member
Memorable Member

@nishchaya Hey,
1st way - You can add a conditional column in Power query based on specific column and go data view sort it by a column like this.

 

HarishKM_0-1712902998676.png

 

or you can create a  disconnected table using enter data or using dax . Create a relationship in between both table and use related dax function to get value based on specific column. like this

 

HarishKM_1-1712903224364.png

 

Then you can select a specific column (In my case country) then sort it by country sort to get desired result.

 

 

Thanks

Harish 

Did I answer your question? Kindly give kudos and Mark my post as a solution!

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.