Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Clustered Bar Chart Sorting

Hi All, 

 

I'm trying to sort the clustered bar chart based with below sample dataset in Power Bi, 

Customer GroupSales 
AAA500
ABA50
ACA200
ADA2000
BBB1000
BQB500
BAB400

 

The original chart available in Power Bi will be looking like this, and only limited sorting options are available (by Sales / by Customers' name alphabetically. 

 

**I generated similar output by using excel

 

I'm trying to achieve sorting like below. Sort the sales in descending orders within each customer groups. Couldn't find any solutions through online so far, appreaciate that if someone could help to advice on this. 

Thanks in advance! 

Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi Anonymous ,

     

    Add a calculated column to above sample dataset.

    Rank Col =
COUNTROWS (
    FILTER (
        Test_9,
        Test_9[Sales ] <= EARLIER ( Test_9[Sales ] )
            && Test_9[Group] = EARLIER ( Test_9[Group] )
    )
)

     

    Choose [Customer] field, click "Sort by Column", choose "Rank Col" from the list.

     

    Chart preview.

    Best regards,

    Yuliana Gu

4 Replies

  • ajayemmadi1's avatar
    ajayemmadi1
    Helper I
    7 years ago

    Hi JOO13,

     

    You can create a condtitional column (Sort_Order). For example in your case 
    AD =1

    AA =2

    AC =3

    AB =4

    BB =5

    BQ =6

    BA =7

    Create a condtional column as per the above format and then do sorting of Customer with respect to Sort_Order Column. I hope your issue will be resolved using this approach.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thanks for the recommendations. It's a good idea but unfortunately it won't work for my case as "Sales" is a Measure. 

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    7 years ago

    Hi Anonymous ,

     

    Add a calculated column to above sample dataset.

    Rank Col =
COUNTROWS (
    FILTER (
        Test_9,
        Test_9[Sales ] <= EARLIER ( Test_9[Sales ] )
            && Test_9[Group] = EARLIER ( Test_9[Group] )
    )
)

     

    Choose [Customer] field, click "Sort by Column", choose "Rank Col" from the list.

     

    Chart preview.

    Best regards,

    Yuliana Gu

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thanks a lot for the recommendations. It's a good idea but unfortunately it won't work for my case as the "Sales" is a measures.