Sorting of legend of line and stacked column chart

[Anonymous]

Hello,

I have this data set for 12 months:

Version	1	2	3	4	5	6	7	8	9	10	11	12	Category
Actual PtD	0,4												B2C
Actual PtD	2,2												SP's
Actual PtD	0,5												B2B
MTP	0,5	0,5	0,5	1,0	1,0	1,0	1,5	1,5	1,5	2,0	2,0	2,0	B2C
MTP	0,5	1,3	1,3	1,8	1,8	1,8	1,8	1,8	1,8	2,0	2,0	2,0	SP's
MTP	1,0	1,3	1,5	1,5	2,0	2,0	2,0	2,0	2,0	2,5	2,5	3,0	B2B

I have created a line and stacked column chart, stacking the Actual PtD per category. The MTP is also cumulated correctly.

When I publish this to PowerBI Service the sorting of the legend goes wrong. MTP should be far right in the legend. When I delete  in the source the category cells for MTP it remains the same issue:

How to solve to have the correct sorting of the legend?

[v-frfei-msft]

Hi @Anonymous,

What is your version of Power BI desktop? Did you use the latest version? Could you please share your pbix to me to test that by my side?

Regards,

Frank

[Anonymous]

I use Version: 2.65.5313.841 64-bit (december 2018)

I cannot share since it contains confidential data. I first have to anonymize the data set. But maybe better to install a later version?

[Anonymous]

@v-frfei-msft I have installed version 2.65.5313.1381 64-bit  but same problem exists.

Hereby the pbix: https://ufile.io/4sbzk 

[v-frfei-msft]

Hi @Anonymous ,

I tested that again by my side, no issue was found.What browser did you use? Please clean your cache and try again. Or you can create a support ticket for help if you are a pro user.

https://powerbi.microsoft.com/en-us/support/

Regards,

Frank

[Anonymous]

@v-frfei-msft  I have issue in both Google Chrome as Internet Explorer. Also after emptying the cache, the same issue exists.