cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vnqt
Helper IV
Helper IV

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 days0-40-20-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

1 ACCEPTED SOLUTION
jdbuchanan71
Super User
Super User

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

 

View solution in original post

2 REPLIES 2
vnqt
Helper IV
Helper IV

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

jdbuchanan71
Super User
Super User

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

 

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors