Graphic Time Order

[carloshluiz]

Hello everybody.

Could you please help me how to put it in chronological order?

I already tried through the option "Axis classification or Legend classification" but it is not in the order it should.

can you help me?

It should be like this:

Today | 1-7 days | 8-15 days | 16-50 days | 51-100 days | >100 days

Thank you 🙂

[v-yangliu-msft · Accepted solution]

Hi  @carloshluiz ,

I created some data:

If we have multiple [Index] in a [Group], direct Sort by may cause one value to correspond to multiple values

We can create a table and use the [Group] of another table to sort.

Here are the steps you can follow：

1. Use Enter data to create a table.

2. Join the relationship between the two tables.

3. Click [Group] - Column tools - Sort by column - [Index] of Table2.

Such a [Group] will correspond to an [Index], and there will be no conflict.

4. Result:

[Group1] of Table 1 – Axis

[Group] of Table 2 – Legend

Best Regards,

Liu Yang

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

[Surya9]

@carloshluiz if the legent you are using(Today | 1-7 days | 8-15 days | 16-50 days | 51-100 days | >100 days) is column then create another column and create index like 1-7 days as 1 , 8-15 days  as 2 and so on then sort the legent with this new clolumn and  then recreate the visual this will fix the issue. 

[amitchandak]

@carloshluiz , You need to create order by column for and assign to this column using the sort column option

Axis classification or Legend classification 1 = [Axis classification or Legend classification]

Axis classification or Legend classification Sort = Switch([Axis classification or Legend classification],

"Today ", 1,

" 1-7 days", 2

//

)

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c