Why my bar chart sorting for aging bucket not working?

[aiyosap]

Hi guru,

I do not know how to resolve this problem and hope you can provides some guidance.

The following is my aging bucket barchart and you will notice the sorting is incorrect as "3-30 days" bucket should be next to "0-3 days" bucket.

The barchart bucket sorting is based on File Date columen.

I tried to sort by other columns, but i got the following error message.

Hope you can shed some light. Thank you.

Regards

Aiyo

[Fowmy]

@aiyosap 
Create another column with the same logic as Aging Bucket but instead of generating the output as '0-30, 30-60 and so on give it a number like 0,1,2 and you can use this column as you sort by column.

[aiyosap]

Hi Fowmy,

I had tried the way you mentioned but I encountered the following error message:

The "Age Sort Ind" field are using:

If Age Range = "0-3 Days", 0,

   if Age Range = "3-30 Days", 3,

      if Age Range = "30-60 Days", 30, 60

The index field populates with correct value.

I have also tried changing the data type (i.e. text and whole number) to the "age sort ind" field, but when come to sort the "age range" field by this new created field, i hits the above error message.

Do you know why?

Thanks,

Aiyo

[aiyosap · Accepted solution]

Hi all, 

I found the solution ...

This is because I created a calculated column referencing another calculated column. This become the circulated issue not allow in Power BI.

I have using the same method but referencing a non calculated column. 

It works.