Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
vnqt
Helper V
Helper V

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 V
Helper V

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors