cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Alex_pg
Advocate I
Advocate I

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:

Alex_pg_0-1625095987781.png

 

Server:

Alex_pg_1-1625096020449.png

 

 

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

Alex_pg_2-1625096215171.png

 

Did anyone run into this issue before?

 

Regards,

 

Alex

 

 

1 ACCEPTED SOLUTION
v-janeyg-msft
Community Support
Community Support

Hi, everyone.

 

 

Update again:

The problem has been fixed and the sort number is working fine now.

 

Regards

Janey

 

 

View solution in original post

24 REPLIES 24
v-janeyg-msft
Community Support
Community Support

Hi, everyone.

 

 

Update again:

The problem has been fixed and the sort number is working fine now.

 

Regards

Janey

 

 

View solution in original post

alexrobe
Advocate II
Advocate II

Same Issue here. The Measure is not even shown in Service. In PowerBI Desktop (most recent Version) everything works just fine.
Pls report as soon as this issue is fixed or if we can do anything on our side / other workaround.

Thanks,

Alex

Tani4ka
Helper I
Helper I

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 ;(

RobWolf
New Member

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.

khairielee
Regular Visitor

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)

Alley_S
Frequent Visitor

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)

Alley_S
Frequent Visitor

Update: all my decomp trees are now sorted correctly (by value desc). It looks like the issue was fixed.

Here too!!!!

joseph_Hanna
New Member

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)

qwertzuiop
Advocate II
Advocate II

Same issue here

v-janeyg-msft
Community Support
Community Support

Hi, @ThomasRL  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

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 @khairielee 

 

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

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

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! 

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

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

@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

ThomasRL
Regular Visitor

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. 

 

ThomasRL_0-1625517425180.png

 

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.