Forum Discussion
vinodDrinkPak
Helper II
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 fil...
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])
vinodDrinkPakHelper II
Helper IIthis 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
Solution Sage
Solution SageMy 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])