Easy Way to Custom Sort Pivot Tables

[nicktayl]

Hi,

I've come across a number of examples of how to do custom sorts and a bit more complex than I was hoping. There must be a simpler way to custom sort a pivot such as this than to have to create a custom index table, create a relationship to the main table field that you wish to index, and then change the field so that it is sorted on the new index table. With pivot tables and Tableau one can drag the fields to the desired position.

It would be nice if I could right click on a field and then define the sort order manually there. 

Thanks,

Nick

[prateekraina]

Hi @nicktayl,

This sorting technique by drag and drop is not yet possible in Power BI.

Thanks !!!

[nicktayl]

@prateekraina Is there an easy workaround?

[Anonymous · Accepted solution]

HI @nicktayl,

Perhaps you can try to refer to below steps if it suitable for your requirement:

Sample table: number(index, value, percent), text(category)

Steps:

1. Add a calculate column to get min value of each catagory.

MinValue = MINX(FILTER(ALL(SampleData),[Catagory]=EARLIER(SampleData[Catagory])),[Percent])

2. Add rank based on minvalue column.

Rank = RANKX(VALUES(SampleData[MinValue]),[MinValue],,ASC) 

3. Create a matrix visual with above columns.(sort by rank)

Regards,

Xiaoxin Sheng