Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I have this table with this values:
QuestionReference | Description | Value | Label | QuestionValue |
P4 | Production | 99 | Excellent (9-10) | P499 |
P4 | Production | 10 | Excellent (9-10) | P410 |
P4 | Production | 9 | Excellent (9-10) | P49 |
P4 | Production | 8 | Good (7-8) | P48 |
P4 | Production | 7 | Good (7-8) | P47 |
P4 | Production | 6 | Right (5-6) | P46 |
P4 | Production | 5 | Right (5-6) | P45 |
P4 | Production | 4 | Bad (0-4) | P44 |
P4 | Production | 3 | Bad (0-4) | P43 |
P4 | Production | 2 | Bad (0-4) | P42 |
P4 | Production | 1 | Bad (0-4) | P41 |
P4 | Production | 0 | Bad (0-4) | P40 |
P16 | Services | 99 | Excellent (9-10) | P1699 |
P16 | Services | 10 | Excellent (9-10) | P1610 |
P16 | Services | 9 | Excellent (9-10) | P169 |
P16 | Services | 8 | Good (7-8) | P168 |
P16 | Services | 7 | Good (7-8) | P167 |
P16 | Services | 6 | Right (5-6) | P166 |
P16 | Services | 5 | Right (5-6) | P165 |
P16 | Services | 4 | Bad (0-4) | P164 |
P16 | Services | 3 | Bad (0-4) | P163 |
P16 | Services | 2 | Bad (0-4) | P162 |
P16 | Services | 1 | Bad (0-4) | P161 |
P16 | Services | 0 | Bad (0-4) | P160 |
Where QuestionValue is a calculated column = QuestionReference&Value
My graphic actually show this:
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!!!
Solved! Go to Solution.
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
Name the Column something like LabelOrder or LabelSort and set the conditions as following:
Your data should now be somthing like this:
Go back to the report and apply the changes.
Make sure you've selected the "Label" column on the right.
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.
Here is the end-result.
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
Name the Column something like LabelOrder or LabelSort and set the conditions as following:
Your data should now be somthing like this:
Go back to the report and apply the changes.
Make sure you've selected the "Label" column on the right.
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.
Here is the end-result.
Great!!!
Thanks a lot mravestein
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |