Sorting in decomposition tree

[prv_1401]

Hi everyone, I want to sort the values in order( Positive value, Negative value and then 0) . So the bars with blue shade at top followed by red and blank bar in the bottom. 

I added another column in order to use the the feature sort by column but it doesnt work and also disorder the product class and week section. Please share your thoughts 
Thank you

[Anonymous]

Hi @prv_1401 ,

Please try sorting [Demand] directly in descending order. If that doesn't work, try writing the value as a measure and placing it on the visual field.

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

Best Regards,

Neeko Tang

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