Forum Discussion

flixius's avatar
flixius
New Member
8 years ago
Solved

Dates in wrong order

Hello,    I imported my SQL Table to Power Bi and created a simple chart. The entries have a DateTime field.   The oldest Entries are starting in October 2017 and the newest are now in March 2018...
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    8 years ago

    Hi flixius,

     

    There are two ways you could refer to.

     

    1. You could use the date hierarchy as the value of X-axis. Then you will get the output below.

     

     

     2. You could create a Month calculated column then sort by date.

     

    The result is below.

     

    If you need additional help please share some data sample. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

     

    Best Regards,

    Cherry

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
8 years ago

Hi flixius,

 

There are two ways you could refer to.

 

1. You could use the date hierarchy as the value of X-axis. Then you will get the output below.

 

 

 2. You could create a Month calculated column then sort by date.

 

The result is below.

 

If you need additional help please share some data sample. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

 

Best Regards,

Cherry