Forum Discussion
Decomposition Tree - Not Ordering when published
Hi there,
I need to help. I began to use the visual Decomposition Tree, on the Desktop works well, but when i published my file the option of ordenation doesn't work.
I realized that my measure is not avaliable in the option sort by, but this happen only after I published my file.
Should be: More Options (three dots) > Sort By > Choose my measure (like the image bellow - in portuguese), but my measure doesn't appear
Could you help me?
The issue has been solved . You can republish your report to Service and then try to sort by measure in your report in Service .
I tested it and everything works fine .
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
6 Replies
It’s a known issue , the ID for ICM is 249481819 .
I will continue to pay attention to this issue, or you can use this ID to ask Microsoft staff about the progress of this issue .
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The issue has been solved . You can republish your report to Service and then try to sort by measure in your report in Service .
I tested it and everything works fine .
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I have the same issue here. If I add multiple fields under "explain by", I can choose those, but not the measure. If I have only one field under "explain by", I can only choose between ascending and descending, but not which field.
In the Power BI desktop app, everything works as expected and I can choose the measure or one of the "explain by" fields to sort by.
This was working fine for my reports a few days ago.
In PBI Desktop decomposition tree is sorted in descending order by the base "Analyze" measure across all "Explain by" fields. Had the report published as an app in PBI Service for a few weeks and worked exactly the same. Can confirm this in a training video I made about the app from a couple of weeks ago.
Then today I viewed the app and the sorting is now in ascending order of "Explain by" fields text labels. I'm the only one with permissions on the workspace and app, and I've made no changes.
Plus, the pbix file still works the same, so republished to PBI Service and updated app but still the same sorting by labels and no option to change it.
Appears some change has been made to PBI Service, but have no idea who to speak to about it. Please would someone fix this.
Yes - this is a weird issue and needs to be fixed ASAP - Hope Microsoft is listening 🙂
Confirm this is now working for my report.
Didn't need to republish. The app just now works as before.
