Forum Discussion
Helper IISort Stacked Bar chart
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?
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])
7 Replies
- parry2k
Super User
vinodDrinkPakthis 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
johnyipSolution Sage
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])
- parry2k
- 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?
- vinodDrinkPak
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
