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.
I want to make a grouped bar chart with Percent on the y-axis, and Lot Number on the x-axis, with each Lot Number grouped into four different bars each representing a different step in a process. I would like the steps within the Lot Numbers to be ordered based on their order within the process. I have included some sample data at the bottom of the post, and here is a picture of the desired outcome:
I made a sort order column and put this into the tooltip field but it still doesn't gice the option to sort the legend with it. At the moment the legend, and bars within each lot number, sort in alphabetical order. Is this possible to change?
Any help would be appreciated.
Regards,
Steven
PS: Here is an example of how the data might look:
Lot Number | Field | Value | Sort Order |
1 | harv | 86 | 1 |
2 | harv | 82 | 1 |
3 | harv | 81 | 1 |
4 | harv | 82 | 1 |
5 | harv | 81 | 1 |
6 | harv | 82 | 1 |
7 | harv | 86 | 1 |
8 | harv | 84 | 1 |
9 | harv | 78 | 1 |
10 | harv | 80 | 1 |
11 | harv | 84 | 1 |
12 | harv | 82 | 1 |
13 | harv | 50 | 1 |
14 | harv | 82 | 1 |
15 | harv | 81 | 1 |
16 | harv | 82 | 1 |
17 | Chrom | 81 | 2 |
18 | Chrom | 107 | 2 |
19 | Chrom | 82 | 2 |
20 | Chrom | 133 | 2 |
21 | Chrom | 80 | 2 |
1 | Chrom | 69 | 2 |
2 | Chrom | 79 | 2 |
3 | Chrom | 80 | 2 |
4 | Chrom | 71 | 2 |
5 | Chrom | 74 | 2 |
22 | Chrom | 122 | 2 |
8 | Chrom | 84 | 2 |
6 | Chrom | 69 | 2 |
7 | Chrom | 78 | 2 |
9 | Chrom | 82 | 2 |
10 | Chrom | 64 | 2 |
11 | Chrom | 85 | 2 |
12 | Chrom | 93 | 2 |
23 | Lo pH | 84 | 3 |
24 | Lo pH | 98 | 3 |
17 | Lo pH | 72 | 3 |
18 | Lo pH | 80 | 3 |
19 | Lo pH | 72 | 3 |
20 | Lo pH | 73 | 3 |
21 | Lo pH | 79 | 3 |
1 | Lo pH | 77 | 3 |
2 | Lo pH | 72 | 3 |
3 | Lo pH | 84 | 3 |
4 | Lo pH | 80 | 3 |
5 | Lo pH | 86 | 3 |
6 | Lo pH | 76 | 3 |
22 | Lo pH | 74 | 3 |
7 | Lo pH | 71 | 3 |
8 | Lo pH | 69 | 3 |
9 | Lo pH | 70 | 3 |
10 | Lo pH | 77 | 3 |
11 | UF/DF | 25587 | 4 |
11 | Lo pH | 77 | 3 |
12 | UF/DF | 78 | 4 |
12 | Lo pH | 67 | 3 |
13 | Chrom | 81 | 2 |
13 | Lo pH | 62 | 3 |
13 | UF/DF | 78 | 4 |
14 | Chrom | 78 | 2 |
14 | Lo pH | 65 | 3 |
15 | Chrom | 83 | 2 |
15 | Lo pH | 67 | 3 |
14 | UF/DF | 77 | 4 |
16 | Chrom | 71 | 2 |
16 | Lo pH | 69 | 3 |
16 | UF/DF | 80 | 4 |
Solved! Go to Solution.
Hi,
Just a quick thouht would be to use the "sort by column" option in the data tab of your report. You could then sort the desired column by the created sort column.
Hi,
Just a quick thouht would be to use the "sort by column" option in the data tab of your report. You could then sort the desired column by the created sort column.
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 |
---|---|
116 | |
104 | |
77 | |
71 | |
51 |
User | Count |
---|---|
146 | |
107 | |
106 | |
89 | |
65 |