- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Sorting order
Hi all,
how can i sort the column on order : Orang , Apple, Melon.
I tried to create a order column but Power BI does not allow to sort "Fruit" column by "Standard Process Order 1" column because a circular dependency
https://1drv.ms/u/s!ApIDnMK2eKiFgkky1BP78dhf7Dm_?e=Tw3u1Y
thanks
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@ktt777 ,
This error is due to calculated column was referring to the same column (Fruit) which you are trying to sort. To achieve the result you need to create one more static table in Power Query editor and then load the table to PBI desktop, then make the relationship between actual table and new table.
Now sort the fruits in new table based on the index created in new table and use the fruit column of static table in the visual. Please refer the attached file,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@ktt777 ,
This error is due to calculated column was referring to the same column (Fruit) which you are trying to sort. To achieve the result you need to create one more static table in Power Query editor and then load the table to PBI desktop, then make the relationship between actual table and new table.
Now sort the fruits in new table based on the index created in new table and use the fruit column of static table in the visual. Please refer the attached file,

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
02-17-2025 07:50 AM | |||
11-21-2024 04:58 AM | |||
01-14-2025 11:49 AM | |||
04-13-2023 04:02 AM | |||
02-04-2025 01:54 AM |
User | Count |
---|---|
89 | |
82 | |
56 | |
41 | |
37 |