Axis order for dynamic group

I have a group of customers by tenure in years.

The visual shows the X-axis of the groups and the Y-axis is a measure called total products.

Is there a way I can show tenure in number order (starting with < 1 Year, and ending with 16+ years) rather than sorted in descending order?

Thank you!

image

@rizzotony ,

The way I would handle this is to go into Power Query and do an Add Column by Examples, creating a numeric sort column that assigns the proper sort value to each bin. Then Close and Apply, and sort the Bin Name column by the numeric sort column. It should then show up in proper order on your bar chart.

I hope that’s helpful.

– Brian

1 Like

That worked. Thank you for the assistance!

Tony

1 Like