cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
MartijnNL Member
Member

Sorting of legend of line and stacked column chart

Hello,

 

I have this data set for 12 months:

 

Version123456789101112Category
Actual PtD0,4           B2C
Actual PtD2,2           SP's
Actual PtD0,5           B2B
MTP0,50,50,51,01,01,01,51,51,52,02,02,0B2C
MTP0,51,31,31,81,81,81,81,81,82,02,02,0SP's
MTP1,01,31,51,52,02,02,02,02,02,52,53,0B2B

 

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

 

Category2.PNG

 

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:

Category3.PNG

 

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

 

 

 

5 REPLIES 5
Community Support Team
Community Support Team

Re: Sorting of legend of line and stacked column chart

Hi @MartijnNL,

 

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

 

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
MartijnNL Member
Member

Re: Sorting of legend of line and stacked column chart

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?

MartijnNL Member
Member

Re: Sorting of legend of line and stacked column chart

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

 

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

 

 

 

Community Support Team
Community Support Team

Re: Sorting of legend of line and stacked column chart

Hi @MartijnNL ,

 

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/

 

Capture.PNG

 

Support Ticket.gif

 

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
MartijnNL Member
Member

Re: Sorting of legend of line and stacked column chart

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