Forum Discussion

nicktayl's avatar
nicktayl
Helper I
9 years ago
Solved

Easy Way to Custom Sort Pivot Tables

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 creat...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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

prateekraina's avatar
prateekraina
Memorable Member
9 years ago

Hi nicktayl,

 

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

Thanks !!!

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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