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  Group Sales  AA A 500 AB A 50 AC A 200 AD A 2000 BB B 10...
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

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.