Sorting order

[ktt777]

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

[Arul · Accepted solution]

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