Forum Discussion
Alphabetical Order on Graph
Hi All,
I am using Clustered Column Chart visual.
On my X axis , I want to display data on alpbatical order.
Current we have four groups. sample data
A, B , C & D.
each group have 4 number measuremnts.
current sequence on X axis
B --- C --- A ---- D -----
I want to display display on X axis as:
A --- B ---- C --- D
Thanks
Hi! A simple solution is to go to options within the clustered column chart visual and use the sort descending/ascending option. Click in sort by and choose the column that contains your 4 groups: A, B, C, D. This should fix your problems. If it doesn't work another thing that can work in this and other cases (especially if there are few categories) is to add an ID column numbering from 1 to N number depending on the order you want and following the steps above to order ascending sorting by the column you just created.
Hope I was able to help!
Best regards, José.
5 Replies
Hi! A simple solution is to go to options within the clustered column chart visual and use the sort descending/ascending option. Click in sort by and choose the column that contains your 4 groups: A, B, C, D. This should fix your problems. If it doesn't work another thing that can work in this and other cases (especially if there are few categories) is to add an ID column numbering from 1 to N number depending on the order you want and following the steps above to order ascending sorting by the column you just created.
Hope I was able to help!
Best regards, José.
hi Jose,
My actuall data starts as:
Amark
Mvolt
Ten nike
Umbrio
when I sort by ASC
Its dsipalys as
Amark, Umbrio, Ten nike , Mvolt
why ?
When the program has "unsortable" data it follows another scheme. Try the second option, modify your table to include a column where you place numbers 1 through 4 for each group depending on the order you want them to be:
Column ID Amark
1 Umbrio 4 Ten nike 3 Mvolt 2 It is important that aside from selecting sort by ASC, you also select which column it is using to make up that ascending order. In this case if you follow my solution you can use sort ascending by ID.
