Alphabetical Order on Graph

[sdhn]

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 

[Anonymous]

Glad to help!

[Anonymous · Accepted solution]

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é.

[sdhn]

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 ?

[Anonymous]

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.

[sdhn]

Actually first one also work.  I did not pick right column ealier.   Thank You very much