sort legend new feature breaks legend order on some report

[mathieulamarre]

I have an issue.

It seems a new feature related to legend ordering was release in november, it may have affected my reports.

Since a couple weeks, some of my reports shows  legend data in reverse order.

On my published reports, I noticed that some of my graphs legends got sorted by descending value by default.

I don't want my users to have to reorder manually, but it isn't something that I can change in power bi desktop before publishing, the options are different and there is no way to reorder the legend. 

Note that the report displays fine locally in power Bi desktop before I publish.

Is it a known issue? Could it get fixed?

[v-cazheng-msft]

Hi @mathieulamarre 

I’ve tested at my side, but I couldn’t repro it. Here is my test on this feature.

Visual in Power BI Desktop:

Visual in Power BI service:

May I know whether Reset to default is in yellow on the top right corner of your report page in Power BI service? If yes, please click this button to bring your report to its original state.

If your issue is not related to Reset to default option, may I know whether there is any other users assigned Contributor, Members or Admin roles in the report workspace have made some changes to this report? If you create a new report and publish it to Power BI service, will you get same issue?

Best Regards,

Community Support Team _ Caiyun

[mathieulamarre]

If I click the reset button, the order is changed to "sort descending" by default

Then If I change the order to "sort ascending", the button "Reset to default" becomes enabled.

It should be the other way around.

I have an other similar report that works as expected, but I don't know why this one behave like that.

I know the order was fine before, cause I pinned that report on a dashboard a long time ago and the order is still fine in the dashboard:

For your other questions, I am the only contributor to the report.

I also tried doing a new report based on the same data, and the order seems ok.

I guess I could redo my report, but I wanted to understand why I have this problem and if someone else does.

Thank you

[v-cazheng-msft]

Hi @mathieulamarre 

Thanks for your reply. I understand you are the author of the report. While, users have Admin, Member or Contributor role in the report workspace can edit the report in Power BI service as well by design. For more details, you can refer Roles in the new workspaces in Power BI - Power BI | Microsoft Docs.

Based on the information from you, the most possibility of the issue is someone has edit the report and change the sort to descending. After that, it becomes the default way of sorting values in the chart.

May I know whether you are using My Workspace or other kind of workspace to publish this report? Is there any other user in your report workspace?

Best Regards,

Community Support Team _ Caiyun

[mathieulamarre]

I just republished my report after downloading the latest version of power BI and by setting "Ascending" as the default value and now it is working fine.

I didn't have the option to reorder the legend before cause I had an older version which didn't correspond to the new feature on the cloud.

It is still weird that only one of my reports had a descending default value, but at least I could fix it by republishing.

Thank you

[v-cazheng-msft]

Hi @mathieulamarre 

That's great! Thanks for your reply! 

Best Regards,

Community Support Team _ Caiyun