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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Raul
Post Patron
Post Patron

Order by which column?

Hello,

I have this table with this values:

QuestionReferenceDescriptionValueLabelQuestionValue
P4Production99Excellent (9-10)P499
P4Production10Excellent (9-10)P410
P4Production9Excellent (9-10)P49
P4Production8Good (7-8)P48
P4Production7Good (7-8)P47
P4Production6Right (5-6)P46
P4Production5Right (5-6)P45
P4Production4Bad (0-4)P44
P4Production3Bad (0-4)P43
P4Production2Bad (0-4)P42
P4Production1Bad (0-4)P41
P4Production0Bad (0-4)P40
P16Services99Excellent (9-10)P1699
P16Services10Excellent (9-10)P1610
P16Services9Excellent (9-10)P169
P16Services8Good (7-8)P168
P16Services7Good (7-8)P167
P16Services6Right (5-6)P166
P16Services5Right (5-6)P165
P16Services4Bad (0-4)P164
P16Services3Bad (0-4)P163
P16Services2Bad (0-4)P162
P16Services1Bad (0-4)P161
P16Services0Bad (0-4)P160

 

Where QuestionValue is a calculated column = QuestionReference&Value

 

My graphic actually show this:

 Captura.JPG

 

I need to represent the item Label in the graphic in this way:

 Excellent (9-10)
 Good (7-8)
 Right (5-6)
 Bad (0-4)

 

How do I order the Label column to show in this order the values?

Thank you very much!!!

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi Raul,

 

You can create an conditional column an use this one to sort the "Label".

 

Go to the query editor and add an Conditional Column

 Sort1Sort1

 

Name the Column something like LabelOrder or LabelSort and set the conditions as following:

2017-03-29 10_59_58-.pngYour data should now be somthing like this:

Sort3Sort3

Go back to the report and apply the changes.

Make sure you've selected the "Label" column on the right.

Sort4Sort4

Now go to "Modeling" and select "Sort by Column". Select here the "LabelOrder"

If you want to Order to be the other way, just click on the "LabelOrder" again.

 

Sort5Sort5

Here is the end-result.

Sort6Sort6

 

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hi Raul,

 

You can create an conditional column an use this one to sort the "Label".

 

Go to the query editor and add an Conditional Column

 Sort1Sort1

 

Name the Column something like LabelOrder or LabelSort and set the conditions as following:

2017-03-29 10_59_58-.pngYour data should now be somthing like this:

Sort3Sort3

Go back to the report and apply the changes.

Make sure you've selected the "Label" column on the right.

Sort4Sort4

Now go to "Modeling" and select "Sort by Column". Select here the "LabelOrder"

If you want to Order to be the other way, just click on the "LabelOrder" again.

 

Sort5Sort5

Here is the end-result.

Sort6Sort6

 

Great!!!

Thanks a lot mravestein

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.