Reply
ktt777
Helper V
Helper V
Partially syndicated - Outbound

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

 

ktt777_0-1699282198178.png

 

 

https://1drv.ms/u/s!ApIDnMK2eKiFgkky1BP78dhf7Dm_?e=Tw3u1Y 

 

thanks

1 ACCEPTED SOLUTION
Arul
Super User
Super User

Syndicated - Outbound

@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,





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


LinkedIn


View solution in original post

1 REPLY 1
Arul
Super User
Super User

Syndicated - Outbound

@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,





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


LinkedIn


avatar user

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 Solution Authors (Last Month)
Top Kudoed Authors (Last Month)