cancel
Showing results 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

New Member

## Order of Y axis in Stacked bar chart

Hi all, Hopefully straight forward- I need to reorder this so that is is in chronological order of ages so 0-4 years, 5-9 years, 10-14 years etc.
However order shows as 0-4 years then 10-14 years as on image.

2 ACCEPTED SOLUTIONS
Solution Specialist

Hello @MK22

the easiest trick is just add 0 before those single digit number.

Because sorting works in numerical and alphabetical order, thats why 5-9 is placed down there.

Thank you.

Community Support

Hi @MK22 ,

(1) Click "Enter Data" to create a new table.

 year Index 0-4 Years 1 5-9 Years 2 10-14 Years 3 15-19 Years 4 20-24 Years 5 25-29 Years 6 30-34 Years 7 35-39 Years 8 40-44 Years 9 45-49 Years 10 50-54 Years 11 55-59 Years 12 60-64 Years 13 65-69 Years 14 70-74 Years 15 75-79 Years 16 80-84 Years 17 85+ Years 18

(2) Create a model relationship.

(3) Select the Year column in Table 2 and sort them by index column.

(3) Place the [Year] column from Table 2 on the visual.

Best Regards,

Neeko Tang

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

2 REPLIES 2
Community Support

Hi @MK22 ,

(1) Click "Enter Data" to create a new table.

 year Index 0-4 Years 1 5-9 Years 2 10-14 Years 3 15-19 Years 4 20-24 Years 5 25-29 Years 6 30-34 Years 7 35-39 Years 8 40-44 Years 9 45-49 Years 10 50-54 Years 11 55-59 Years 12 60-64 Years 13 65-69 Years 14 70-74 Years 15 75-79 Years 16 80-84 Years 17 85+ Years 18

(2) Create a model relationship.

(3) Select the Year column in Table 2 and sort them by index column.

(3) Place the [Year] column from Table 2 on the visual.

Best Regards,

Neeko Tang

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

Solution Specialist

Hello @MK22

the easiest trick is just add 0 before those single digit number.

Because sorting works in numerical and alphabetical order, thats why 5-9 is placed down there.

Thank you.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.