Matrix column value sorting ( aging bucket). Please help

[Anonymous]

Hi Power Bi Gurus, 

I have an aging bucket field with values (0-7 Days, 8-15 Days, 16-30 Days....up to 120+ Days),  and I use a matrix table display the amount by managers by each bucket, but currently, the bucket values columns are not in the order I expect.   Please see below.  

I ready couple disussion notes from the forum,  and I create a "bucket sort" field in my orginal data file with value (1-7),  and in the "Data" view,  I choose "Bucket sort" column, and click on  "Sort by column",   nothing happend, it still show the first row with value starting as "3"....Am I following  the wrong direction?  Please advise how to sort the column values ... 

Also, I have a similar problem with this aging bucket field using as a color legend, it also won't show in the expected order.

Any help is very much appreiciated! thank you!!.

Best,

Flora

[RMDNA · Accepted solution]

@Anonymous,

You'll want to select the column you'd like to sort (your aging buckets), and then the column to sort it by (Bucket Sort) in Sort by Column.

In your original case, you were trying to sort Bucket Sort by itself, which wouldn't do anything.

[Anonymous]

@RMDNA OMG! This just works!    Thank you!! 🙂