Decomposition Tree

MG444 · ‎01-23-2024

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 · ‎01-23-2024

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 · ‎01-23-2024

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...

Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696