Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply

Change order within groups of a grouped bar chart.

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 OutcomeDesired 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

1harv85.6751
2harv82.251
3harv80.7291
4harv82.1781
5harv81.4111
6harv82.0981
7harv85.5521
8harv83.6711
9harv78.3371
10harv80.3571
11harv83.8521
12harv81.9591
13harv50.051
14harv82.0631
15harv81.1781
16harv82.0221
17Chrom80.9092
18Chrom107.1762
19Chrom82.2842
20Chrom133.3462
21Chrom80.322
1Chrom69.4922
2Chrom79.0362
3Chrom80.3012
4Chrom71.1472
5Chrom74.142
22Chrom122.4342
8Chrom84.4452
6Chrom69.2882
7Chrom77.7042
9Chrom82.4352
10Chrom64.2552
11Chrom85.2082
12Chrom92.9552
23Lo pH84.3853
24Lo pH97.5483
17Lo pH71.6863
18Lo pH79.8043
19Lo pH72.2613
20Lo pH73.4653
21Lo pH79.453
1Lo pH76.9763
2Lo pH72.0273
3Lo pH84.1663
4Lo pH79.6393
5Lo pH85.6593
6Lo pH76.4423
22Lo pH73.9383
7Lo pH71.4753
8Lo pH69.0433
9Lo pH70.2533
10Lo pH77.1733
11UF/DF25586.994
11Lo pH77.3073
12UF/DF78.0054
12Lo pH66.943
13Chrom81.4892
13Lo pH61.9933
13UF/DF78.0284
14Chrom77.9892
14Lo pH65.4993
15Chrom82.6572
15Lo pH66.793
14UF/DF76.5624
16Chrom71.1092
16Lo pH69.1493
16UF/DF80.1984
1 ACCEPTED SOLUTION
v-stephen-msft
Community Support
Community Support

Hi @stevenmcginnis ,

 

Do you want the visual like the following?

vstephenmsft_0-1662087691711.png

Because there's a particularly large value in your data, the visual is a bit exaggerated.

vstephenmsft_1-1662087719275.png

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.

 

 

 

 

View solution in original post

1 REPLY 1
v-stephen-msft
Community Support
Community Support

Hi @stevenmcginnis ,

 

Do you want the visual like the following?

vstephenmsft_0-1662087691711.png

Because there's a particularly large value in your data, the visual is a bit exaggerated.

vstephenmsft_1-1662087719275.png

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.

 

 

 

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors