Sorting axis with two variables

[sroemer26]

Hello,

I am really close to having my chart exactly how I want it.

I would like to see my top scrap contributors each month by part number (or NCR Item number) / (NCR - Non conformance report)

However PowerBI is currently sorting my columns alphabetically by part number.

Please help - how do I get PowerBI to sort from USD Scrap cost but keep months in chronological order (rearranging Item number)

[sroemer26 · Accepted solution]

I rephrased / reposted my question, and was able to get an answer.

Solved: Re: How to rank / sort when you have two variables... - Microsoft Fabric Community

[Anonymous]

Hi @sroemer26 ,

1. Place the fields you want to use in the table visual.

2. Hold down the shift key and select the two fields you want to sort on the x-axis.

3. Select this visual and change it to a clustered column chart.

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[sroemer26]

Well, I tried that, but still no dice. Still May, April and March, and not from least to greatest. 🤔

[Anonymous]

Hi @sroemer26 ,

1. Adjust the sorting of Month Name, Year columns so that they are sorted by month number or other ordered columns.

2. Make sure to put the right fields in the right places.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[sroemer26]

I found this similar post, but I am still not getting the desired result

Solved: Re: X-Axis with two levels - Sorting should be dif... - Microsoft Fabric Community

NewSortDAXColumns after NewSort