Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |