Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 🙂
Solved! Go to 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
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
@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.
@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
User | Count |
---|---|
103 | |
88 | |
78 | |
71 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |