Month sort not working on graph

[anilkumarkk]

Hi I have created a revenue development graph for Jan to Dec for Act vs. Budget and forecast comparison. The problem is X axis month sorting in different way.  in my raw data, month-showing i.e. Jan, Feb, Mar to Dec and its sorted format in excel itself. I have created a separate table for month sorting adding numbers i.e. Jan = 1, Feb = 2 and Dec = 12 and joined the month relationship and sorted the numbers. However, it's not working. Please help me.

[anilkumarkk]

Thanks for helping me out. It's working fine for me now.. 🙂

[eliasayyy]

hello in your table , press on the month column and select sort by columns , choose the order 

[eliasayyy]

result

@anilkumarkk 

[anilkumarkk]

Yes, did it again.. No luck

[eliasayyy]

oh wait did you sort the order column or the month column ? you need to select the mnth column and then press sort by colum nand refer to order @anilkumarkk 

[eliasayyy]

ok how about he visaul sorting ? i also posted images

[anilkumarkk]

Hi, thanks for your reply.. I tried it but no luck. Even I created a date table and joined the relationship and sorted the column.. Still it's not getting sorted.

[eliasayyy]

did you do the same way i shwed in the images?

[anilkumarkk]

I did it the same.. After sorting the column, I sorted on the graph as well. The graph look like below-

[eliasayyy]

@anilkumarkk have you tried checking the visual if its sorting by date or value?

before

after

[eliasayyy]

did it work ? @anilkumarkk 

[anilkumarkk]

No, it's not working.. I don't know why it is.. Strange.

[eliasayyy]

mmmm so you tried sorting by column and you tried the visual sort? 

[anilkumarkk]

Yes, both I tried

[eliasayyy · Accepted solution]

are you able to share the bpix file?