Forum Discussion

Krahnin's avatar
Krahnin
New Member
10 years ago

How to Sort Visualization by Month

I have a report powering a dashboard visualization which I would like to sort by month (text names). Currently, they display out of order. Investigating this issue, I see other discussions where it w...
Krahnin's avatar
Krahnin
New Member
9 years ago

I did not. Actually, the column is literally straight numbers within the associated spreadsheet. As I simply needed 1-12, I manually entered them as opposed to writing an equation for it. i.e. Column A (Sort Order) contains numbers 1-12 (A1=1, A2=2, etc.) formatted as Numbers. Column B (Month) contains January-December formatted as text. There is no equation from one column to populate the other in either direction. 

MEhrenmueller's avatar
MEhrenmueller
Icon for Most Valuable Professional rankMost Valuable Professional
9 years ago

OK.

 

Unfortunately I did not succed in duplicating that effect.

 

Could you upload your file (after you anonymonized the containing data) so I could play with it and the effect?