Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |