topic Re: Decomposition tree sort value Desktop vs Server changing in Report Server

Decomposition tree sort value Desktop vs Server changing

Anonymous — Wed, 30 Jun 2021 23:40:02 GMT

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

Re: Decomposition tree sort value Desktop vs Server changing

v-janeyg-msft — Mon, 05 Jul 2021 03:23:30 GMT

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

Re: Decomposition tree sort value Desktop vs Server changing

Anonymous — Mon, 05 Jul 2021 03:30:23 GMT

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

Re: Decomposition tree sort value Desktop vs Server changing

Anonymous — Mon, 05 Jul 2021 12:13:32 GMT

I'm having the same issue since a few days and I am also looking for a solution for that.

Same Version: Version: 2.94.921.0 64-bit (Juni 2021)

Re: Decomposition tree sort value Desktop vs Server changing

Anonymous — Mon, 05 Jul 2021 20:37:50 GMT

Same problem here.

Can filter by the measure on the desktop version, can't on the Power BI Service.
Tryed to republish, refresh, take out and put back measures : not results.

Version: 2.94.921.0 64-bit (juin, 2021)

Enclosed a screen shot.

Re: Decomposition tree sort value Desktop vs Server changing

v-janeyg-msft — Tue, 06 Jul 2021 07:50:02 GMT

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

Re: Decomposition tree sort value Desktop vs Server changing

kientt — Tue, 06 Jul 2021 11:04:27 GMT

I'm having the same problem, cannot sorting by value, only sorting by category in the portal (cannot choose analyze field to sort).

My Version: 2.94.921.0 64-bit (June 2021)

Re: Decomposition tree sort value Desktop vs Server changing

qwertzuiop — Tue, 06 Jul 2021 11:46:26 GMT

Same issue here

Re: Decomposition tree sort value Desktop vs Server changing

Anonymous — Tue, 06 Jul 2021 12:32:53 GMT

same issue here. the problem is in the Power BI Service.

it is missing the (Analyz Field) sort regardles it is a measure or value such as amont in the data.

Version: 2.94.921.0 64-bit (June 2021)

Re: Decomposition tree sort value Desktop vs Server changing

kientt — Tue, 06 Jul 2021 14:22:19 GMT

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?" 😞

Re: Decomposition tree sort value Desktop vs Server changing

Anonymous — Tue, 06 Jul 2021 17:30:10 GMT

I am experiencing this probem as well. In desktop, my decomp tree is sorted descending by value. In service, it is sorted ascending by category and does not allow me to change it.

Version: 2.92.706.0 64-bit (April 2021)

Re: Decomposition tree sort value Desktop vs Server changing

Anonymous — Wed, 07 Jul 2021 03:08:07 GMT

I'm having the same issue as well. Sort by 'Analyze' is missing when published to Power BI Service. Have performed countless trials and errors but still come to the same problem.

Version: 2.90.782.0 64-bit (February 2021)

Re: Decomposition tree sort value Desktop vs Server changing

v-janeyg-msft — Wed, 07 Jul 2021 03:50:34 GMT

@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

Re: Decomposition tree sort value Desktop vs Server changing

kientt — Wed, 07 Jul 2021 07:02:45 GMT

I want to ask one more question, if i reinstall the older version of PowerBi Desktop will this fix the problem?

Re: Decomposition tree sort value Desktop vs Server changing

v-janeyg-msft — Wed, 07 Jul 2021 07:09:26 GMT

@kientt I'm not sure, you can make a backup and try it. The pbi service also has a version, I'm not sure where the problem is and need to wait for the engineer to deal with.

Best Regards

Janey Guo

Re: Decomposition tree sort value Desktop vs Server changing

gbeauchemin55 — Wed, 07 Jul 2021 21:23:11 GMT

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.

Re: Decomposition tree sort value Desktop vs Server changing

RobWolf — Thu, 08 Jul 2021 02:20:14 GMT

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.

Re: Decomposition tree sort value Desktop vs Server changing

v-janeyg-msft — Thu, 08 Jul 2021 02:34:00 GMT

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

Re: Decomposition tree sort value Desktop vs Server changing

kientt — Mon, 12 Jul 2021 10:04:44 GMT

Hi @v-janeyg-msft,

Have you heard from the engineers, is there a timeline for a fix?
Actually a lot of my reports are built on top of Decomposition Tree and it's hard to replace by other visuals. So I temporarily providing an offline version running on PowerBI Desktop while I wait for the online version to be fixed. Looking forward to hearing from you soon.
Sincerely thank!

Re: Decomposition tree sort value Desktop vs Server changing

v-janeyg-msft — Mon, 12 Jul 2021 10:16:00 GMT

Hi, @kientt

Sorry, there is no specific fix time, but the cause of the problem has been found. I will notify you if there is a update.

Best Regards

Janey Guo