Forum Discussion
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
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,
1 Reply
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,