Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 ?
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |