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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
RG92
New Member

Sort table Age Range

I have a table with a 'Category' column with several categories, one of the catogories is Age range.
The other column is 'group' which is split into:

Less than 25

26-30

31-40

41-54

55+ 

 

I have created a table visual in report view to filter this only to the Age rage show the values of the group. 
however, the table sorts the columns as

26-30, 31-40, 41-54, 55+, Less than 25.

I want the table to be sorted so it shows Less than 25,26-30,31-40,41-54,55+ 

1 REPLY 1
DataVitalizer
Solution Sage
Solution Sage

Hi @RG92 

I understand that you want to display rangers in a certain order.

  1. I suggest that you create a new static table with those ranges
  2. Add a column 'Order' with numbers (order of values)
  3. Load the table and link it to the fact one
  4. In your new table select ranges column and click Column Tools / Sorting by Order column
  5. Use this one in your visual and you get the desired result


Did it work ?  👍 A kudoswould be appreciated ‌‌📢 Mark it as a solution to help spreading knowledge

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors