Decomposition Tree

[MG444]

My decomposistion tree includes 3 levels of data. On my Power BI Desktop, the graphic sorts my data at each level highest to lowest. However, when I publish the report, the graphic is not sorted highest amount to lowest. It appears to sort Z to A vs the dollar amount. How do I get my published version to look like my desktop version? 

[Anonymous]

Hi @MG444 

Please try sorting field 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.

Regards,

Nono Chen

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

[AmiraBedh]

I found this old thread and it seems like a bug :

https://community.fabric.microsoft.com/t5/Service/Decomposition-Tree-Not-Ordering-when-published/m-p...