Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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.
Solved! Go to Solution.
@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.
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
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!
@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.
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
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!
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 59 | |
| 43 | |
| 42 | |
| 23 | |
| 17 |
| User | Count |
|---|---|
| 190 | |
| 122 | |
| 96 | |
| 66 | |
| 46 |