Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
I have a bar chart, on the x-axis I have Lots, on the y-axis percentages. Each lot is divided into different steps within a process. I want to sort the steps within the Lots in the order they come within the process. I have created a sort order column but for some reason I can't sort the legend by this sort order. Here is a picture of the desired outcome:
Desired Outcome
But at the moment my chart only sorts the legend in alphabetical order (and the order of the bars within each Lot). Is this something that is possible to do?
Any help would be appreciated.
Regards,
Steven
Here is an example of the data I currently have:
Lot_NumberFieldValueSort Order
1 | harv | 85.675 | 1 |
2 | harv | 82.25 | 1 |
3 | harv | 80.729 | 1 |
4 | harv | 82.178 | 1 |
5 | harv | 81.411 | 1 |
6 | harv | 82.098 | 1 |
7 | harv | 85.552 | 1 |
8 | harv | 83.671 | 1 |
9 | harv | 78.337 | 1 |
10 | harv | 80.357 | 1 |
11 | harv | 83.852 | 1 |
12 | harv | 81.959 | 1 |
13 | harv | 50.05 | 1 |
14 | harv | 82.063 | 1 |
15 | harv | 81.178 | 1 |
16 | harv | 82.022 | 1 |
17 | Chrom | 80.909 | 2 |
18 | Chrom | 107.176 | 2 |
19 | Chrom | 82.284 | 2 |
20 | Chrom | 133.346 | 2 |
21 | Chrom | 80.32 | 2 |
1 | Chrom | 69.492 | 2 |
2 | Chrom | 79.036 | 2 |
3 | Chrom | 80.301 | 2 |
4 | Chrom | 71.147 | 2 |
5 | Chrom | 74.14 | 2 |
22 | Chrom | 122.434 | 2 |
8 | Chrom | 84.445 | 2 |
6 | Chrom | 69.288 | 2 |
7 | Chrom | 77.704 | 2 |
9 | Chrom | 82.435 | 2 |
10 | Chrom | 64.255 | 2 |
11 | Chrom | 85.208 | 2 |
12 | Chrom | 92.955 | 2 |
23 | Lo pH | 84.385 | 3 |
24 | Lo pH | 97.548 | 3 |
17 | Lo pH | 71.686 | 3 |
18 | Lo pH | 79.804 | 3 |
19 | Lo pH | 72.261 | 3 |
20 | Lo pH | 73.465 | 3 |
21 | Lo pH | 79.45 | 3 |
1 | Lo pH | 76.976 | 3 |
2 | Lo pH | 72.027 | 3 |
3 | Lo pH | 84.166 | 3 |
4 | Lo pH | 79.639 | 3 |
5 | Lo pH | 85.659 | 3 |
6 | Lo pH | 76.442 | 3 |
22 | Lo pH | 73.938 | 3 |
7 | Lo pH | 71.475 | 3 |
8 | Lo pH | 69.043 | 3 |
9 | Lo pH | 70.253 | 3 |
10 | Lo pH | 77.173 | 3 |
11 | UF/DF | 25586.99 | 4 |
11 | Lo pH | 77.307 | 3 |
12 | UF/DF | 78.005 | 4 |
12 | Lo pH | 66.94 | 3 |
13 | Chrom | 81.489 | 2 |
13 | Lo pH | 61.993 | 3 |
13 | UF/DF | 78.028 | 4 |
14 | Chrom | 77.989 | 2 |
14 | Lo pH | 65.499 | 3 |
15 | Chrom | 82.657 | 2 |
15 | Lo pH | 66.79 | 3 |
14 | UF/DF | 76.562 | 4 |
16 | Chrom | 71.109 | 2 |
16 | Lo pH | 69.149 | 3 |
16 | UF/DF | 80.198 | 4 |
Solved! Go to Solution.
Hi @stevenmcginnis ,
Do you want the visual like the following?
Because there's a particularly large value in your data, the visual is a bit exaggerated.
You could check more details from my attachment.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @stevenmcginnis ,
Do you want the visual like the following?
Because there's a particularly large value in your data, the visual is a bit exaggerated.
You could check more details from my attachment.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
80 | |
65 | |
52 | |
49 |
User | Count |
---|---|
212 | |
89 | |
79 | |
68 | |
60 |