Is this kind of sorting actually possible in Power BI?

[RingoSun]

I have this bar chart above and I want to change the way it is sorted. So the blue one which is the Client, I want it to always be the first one in the visual and then the rest I want them to be sorted from highest to lowest.

So it should look something like below.

Is this actually possible in Power BI? I've been playing around with the sort by columns and other stuff but I just can't get my desired result. 

Sample PBIX File

[v-yanjiang-msft · Accepted solution]

Hi @RingoSun ,

According to your description, I download your sample data, here's my solution.

Create a calculated column in the SOS table.

Rank =
IF (
    RELATED ( 'BrandDim'[Brand] ) = "Client",
    10000,
    RANKX (
        FILTER ( 'SOS', MAX ( 'BrandDim'[Brand] ) <> "Client" ),
        SUMX (
            FILTER ( 'BrandDim', 'BrandDim'[Brand] = MAX ( 'BrandDim'[Brand] ) ),
            'SOS'[Quantity]
        ),
        ,
        ASC,
        DENSE
    )
)

Put the rank column in the visual tooltip and sort the visual axis by rank, get the result.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

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

[RingoSun]

I've been trying out solutions to achieve this without any success so I guess it's safe to assume that this is just impossible to acheive in Power BI

[Tahreem24]

@RingoSun Check these videos:

https://www.youtube.com/watch?v=CpBy79AawVw

https://www.youtube.com/watch?v=uZLmWz60_do

[RingoSun]

@Tahreem24 

That works for making the client to always be the first one in the visual but does not work for arranging the rest from highest to lowest