Simple Line Chart Help Please

[cpaysinger]

HI,

I have been struggling with this for a while now and cannot figure it out. In the first picture below I have created a simple line chart, but the x axis is always out of order. In my data view (second picture below) the data is sorted by the week of the year column which goes from 1 to 52, but when I go back to chart it is always out of order starting with 1 then 10 then jumping to 2 or 4 see below. Any ideas please help!

Thank you in advance,

Casey

[v-yulgu-msft]

Hi @cpaysinger,

Please check the data type of [Week of Year] to ensure it is numeric.

Regards,

Yuliana Gu

[Anonymous]

Humm, that is odd. Try using Sort by Column under the Modeling Tab. Start first by selecting the field in the FIELDS window. The Sort by Column should be selectable. Make sure it's sorting on itself (should be the default).  I tried to replicate by everything I used sorted fine. 

I do use a date/Calendar table. Are you using one? If not, I highly recommend it. Dates will cause you many troubles without one, this could be one.