Forum Discussion
Decomposition tree sort value Desktop vs Server changing
Hi There,
My issue is very simple.
When I publish a report on PBI server, the sort applied to a decomposition tree (Descending by value) is not respected and instead it sorts descending alphabetically.
Desktop:
Server:
What I tried:
- Check a similar post on the community: https://community.powerbi.com/t5/Service/Decomposition-Tree-has-no-default-sort-on-my-online-report/m-p/1206762#M101791 This does not apply to my issue as I do not want to sort the values on the dataset.
- Revert to default on the server. It doesn't work, the sort alphabetically is the default on the server
- Edit on the server and Sort but the only option is an Alphabetical sort:
Did anyone run into this issue before?
Regards,
Alex
Hi, everyone.
Update again:
The problem has been fixed and the sort number is working fine now.
Regards
Janey
25 Replies
Hi, Anonymous and all
I will test it and report this issue, and I will update it as soon as there is news.
Best Regards
Janey Guo
Please hurry up, my boss is asking how I can upload a bunch of data without sorting, "The data needs to be sorted before showing, do you understand what I'm saying?" 😞
kientt The issue was reported yesterday, and the engineer is already following up and processing it. It will take some time. You can try to use other visuals to show the result.
I will notify you as soon as there is new news.
ICM: 249184181
Best Regards
Janey Guo
Hello Janey,
Do we have an update from the engineers? I am also experiencing this issue which is inconveniencing my report users as it renders the visualization essentially useless. The issue is prevalent across multiple reports and appears only in the service (my desktop pbix files are sorted correctly).
Thanks,
Gabrielle B.
Hi, gbeauchemin55 kientt Anonymous
The product group has reproduced the problem, but there was no code change recently for DecompTree, so more investigation for the reason is needed. Please be patient and thank you for your support and understanding.
Best Regards
Janey Guo
Same issue here
Hi, everyone.
Update again:
The problem has been fixed and the sort number is working fine now.
Regards
Janey
Long shot since this post is so old, but I'm experiencing this with 2.152.1279.0 64 bit (March 2026).
I am having the same Decomposition Tree issue. Works fine on the Desktop, but in the Service I no longer have the option to sort on Value.
Hi, Anonymous
If I understand correctly, you created a report using the rs version of the desktop, and the decomposition tree above was not sorted by value after publishing to report server, right? What's your desktop version? Do you have any changes after publishing?
Best Regards
Janey Guo
Hi v-janeyg-msft ,
Yes that's correct. I sorted the tree by values in desktop version 2.94.921.0 64-bit (June 2021).
When published into the server the tree loses the the sorting by values and is instead sorted by category (state alphabetical).
Regards,
Alex
Same here. I'm presenting the report to the busines in a few days and it will fail bacause all decomp trees are useles to use in services ;(
