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

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

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
Power Participant
Power Participant

@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
Power Participant
Power Participant

@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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 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 Kudoed Authors