Forum Discussion

MG444's avatar
MG444
New Member
2 years ago

Decomposition Tree

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? 

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.