Forum Discussion
Sort Legend
Hello,
I have 4 columns (more to come) need to be sorted in different visuals. Could you please advise any other solution without creating a table for each column?
| <=5 days | 0-4 | 0-2 | 0-50 |
| >5 days and<=10 days | >4-8 | >2-4 | >50-100 |
| >10 days and <=30 days | >8-12 | >4-8 | >100-250 |
| >30 days and <=90 days | >12-16 | >8-16 | >250-500 |
| >90 days | >16-20 | >16-24 | >500-750 |
| >20-24 | >24-32 | >750-1000 | |
| >24-32 | >32-48 | >1000-1500 | |
| >32-40 | >48-64 | >1500-2000 | |
| >40 | >64-96 | >2000-4000 | |
| >96-128 | >4000-6000 | ||
| >128-192 | >6000-8000 | ||
| >192-256 | >8000-12000 | ||
| >256 | >12000-16000 | ||
| >16000 |
Thank you in advance.
tg
You would need a number column for each of the 4 that defines the sort order to use. Take a look at this article that goes over the topic.
https://www.myonlinetraininghub.com/sort-by-columns-in-power-bi
2 Replies
You would need a number column for each of the 4 that defines the sort order to use. Take a look at this article that goes over the topic.
https://www.myonlinetraininghub.com/sort-by-columns-in-power-bi