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.
Hi
I am in the education sector and trying to produce a chart which is sorted by a 15 point scale (A+ A A- .... E+ E E-) with the alphabetical descriptors and not numerical ones.
The chart will sort alphabetically fine but goes A A- A+ etc instead of A+ A A-.
Any ideas on how this can be done?
Thank you
Solved! Go to Solution.
Hi @Anonymous
Try to sort Grade column manually by following way-
Grade Sort = SWITCH(Table1[Grade_Base],"A+",1,"A",2,"A-",3,"B+",4,"B",5,"B-",6,"C+",7,"C",8,"C-",9,10)
2. Sort Grade Column by Grade sort(created column) under the modeling tab in ribon pallet.
For more details see the pbix file.
Regards,
Angad
Hi @Anonymous
Try to sort Grade column manually by following way-
Grade Sort = SWITCH(Table1[Grade_Base],"A+",1,"A",2,"A-",3,"B+",4,"B",5,"B-",6,"C+",7,"C",8,"C-",9,10)
2. Sort Grade Column by Grade sort(created column) under the modeling tab in ribon pallet.
For more details see the pbix file.
Regards,
Angad
how do you disable the auto sort feature on the visuals ?
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 |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |