Sort Legend

[Anonymous]

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

[Anonymous]

thank you for this share. I would apply this solution. 

[jdbuchanan71 · Accepted solution]

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