Sorting - Power BI DEsktop

[Anonymous]

Hi,

I've got a table below:

Books	1 moth	3 moth
Harry Potter 1	34	12
Benchmark	23	45
Outperformance	-11	33
Shantaram	30	56
Benchmark	23	78
Outperformance	-7	22

How can I get the sorting order to first display book name, then benchmark ad then outperformance? Some benchmarks are names (Eg: ASX) instead of Benchmark and therefore I cant use sort by ascending order. When I use another column for sort order  and assign each of them 1,2 and 3 Power BI throws an error. (There cant be more than one value in Orering for the same value in Book_name')

Any advice is greatly appreciated.

Thansk,

ara_4

[v-stephen-msft]

Hi @Anonymous ,

Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your table and your problem or share me with your pbix file from your Onedrive for Business.

Best Regards,
Stephen Tao

[v-stephen-msft · Accepted solution]

Hi @Anonymous ,

It is suggested that you add the index column into the visual to sort.

The index column can be created in the Power Query Editor.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , I you table create a column sort order

Books 1= [Books]

book sort =

Switch (True() ,

[Books] = " benchmark",2,

[Books]= "outperformance",3,

1

)

Sort Books 1 on book sort and use books 1 in visual

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

[Anonymous]

Hi @amitchandak 

I get a circular dependency error.