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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request 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
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

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