Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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
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?
@v-frfei-msft I have installed version 2.65.5313.1381 64-bit but same problem exists.
Hereby the pbix: https://ufile.io/4sbzk
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
@v-frfei-msft I have issue in both Google Chrome as Internet Explorer. Also after emptying the cache, the same issue exists.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |