Dates in chronological order

[Ottmar_W]

Hey,

By making a line graph I have some difficulties by ranking my dates in chronological order. 

How can I solve this problem? I have this with all of my Line Graph i'm making.

Thanks in advance!

[BalaVenuGopal]

Generate Datekey and select your date column and sort by Datekey it will order your date

[Ottmar_W]

@BalaVenuGopal how can I do that? 

thanks in advance

[BalaVenuGopal · Accepted solution]

HI 

In the Datamodel just you add custom column 

DateKey = ([Year]*10000)+([Month Nbr]*100)+[DayOfMonth])

Then go to your report designer and select datecolumn and choose sortby and select DateKey 

Hope this will work 

[Ottmar_W]

@BalaVenuGopal

Hi,

Is there a possibility that you can make it for me?

Because I really don't understand what I need to do.

Thanks in advance

[Ottmar_W]

Hi,

Thanks for all the help! 

[BalaVenuGopal]

Please make this status resolved like my answer if it works for you happy to share knowledge !!!!!!

[v-chuncz-msft]

@Ottmar_W,

You need to convert the data type from text to date/time.

[Ottmar_W]

@v-chuncz-msft how can I do that?

Thanks in advance