revise the order in PBI matrix

[pang22]

Hi,

In PBI report view matrix, how to revise the order  according to below prefer layout?

Prefer layout

1 - 30 DAYS

31 - 60 DAYS

61 - 90 DAYS

91 - 180 DAYS

181 - 270 DAYS

271 - 360 DAYS

360 DAYS+

Not overdue

[Anonymous]

Hi @pang22 ,

As far as I know, add a new column to sort [Due_Date period 1] is a good idea. However, if you create  [Due_Date period 1] and new column by Dax, Power BI will return a circule error.

I think you need to add [Due_Date period 1] and new column in Power Query Editor.

Please try conditional column in Power Query Editor.

Best Regards,
Rico Zhou

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

[ChiragGarg2512]

@pang22 , There needs to be another column on which this column can be sorted. Create a column using IF or SWITCH statement that can give these values an ID of sorts. Then sort the customer column based on this new ID column.