2 dimension bar chart - looking to sort by both dimensions

[mic_wang]

Hi Everyone,

I have 2 dimensions, Product Strength and Quarter. The measure column has number of production runs. I'd like to sort my X axis (dimensions) by strength from smallest to largest (already done). However, I am having trouble adding another sort that makes the Quarter go Q1,Q2,Q3,Q4... in order. 

Does anyone know how to add an additional sort? Kindly let me know if I can clarify anything

Thanks all,

Wang

[OmarBenSalem]

In the sorting Tab; go to quarters and sort it by Alphabet asc

[mic_wang]

Hi Omar, 

I'm currently trying this solution but the issue still remains - please see attached screen shot. Do you know any other potential fixes?

Thanks again

[OmarBenSalem · Accepted solution]

Put the sum(measure) in first position (drag it)

quarter in second position

strength in 3rd position and keep its sorting automatic

[mic_wang]

Hi Omar,

Thanks for the suggestion - I made the attached changes for the solution.