Sort Stacked Bar chart

[vinodDrinkPak]

Hi,

I want to sort , my stacked bar chart, while keeping the "Other" Category as last Bar and ofcourse the rest of the company should be sorted in descending order

here is my link to pbix file

https://drive.google.com/file/d/1XN5SnO_rJOeMjjnxyo14DFbMPj5-06jw/view?usp=sharing

Not sure how can i achieve this?

[vinodDrinkPak]

@johnyip 

this works, but only problem is i don't want to show this as tool tip, seee below it gets mixed up in the tool tip and doesn't look really good, anything we can do ?

[johnyip]

I am afraid no. Please vote on this Microsoft Idea and they may eventually add support to this ???

[parry2k]

@vinodDrinkPak you mean this?

[vinodDrinkPak]

@parry2k  Excellent, you are awesome, i have beeen sitting to find a solution for this, since couple of days

thank you so much, Can you share the solution please?

[parry2k]

@vinodDrinkPak is this what you are looking for:

[vinodDrinkPak]

@parry2k 

this i manage to do  it as well, but the issue is , we still need to sort  the category from Descending, for example in the above pic monster should be the top bar based on the overall total, then Celsius etc

[johnyip · Accepted solution]

@vinodDrinkPak 

My closest answer is to create this measure and then put it in tooltip, and sort it descendingly.

No of Pallets_RANK = 
IF(MAX(LOCATION_INVENTORY[Customer Name for Sorting])="Other",-99999,[No of Pallets])