Forum Discussion

DH27's avatar
DH27
Frequent Visitor
6 years ago
Solved

Python Visual - datestamps on x-Axis all over the place

Hi,  I've created some Python visualisations and for the most part, they are working just fine.  However, there is one visualisation, where I've got either bizarre date stamps (attachment 1), or i...
Need Help
  • DH27's avatar
    DH27
    6 years ago

    Hi,

     

    a week has passed and I managed to narrow the problem down to the following phenomenon:

    In most of my graphs, the time stamps on the x-axis are mixed up, even though the data is sorted

    correctly in the data-menu.

    I have made another screenshot of the behaviour to further clear up the problem:

    As the visualisation is created with Python Visual, I am not able to sort the data manually in the report-menu.

    Furthermore, it looks like only the labels on the x-axis are mixed up, the data itself seems to be sorted correctly.

     

    Thanks for any answers regarding this problem.

DH27's avatar
DH27
Frequent Visitor
6 years ago

Hi Anonymous 

 

thanks for your comment, the data type is text.

Unfortunately, I don't have the sort by feature for this visual.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi DH27 ,

 

 

Since i can't restore your scenario, can you share your file to me if you don't have any Confidential Information?

 

Best Regards,

Jay

  • DH27's avatar
    DH27
    Frequent Visitor
    6 years ago

    Hi Anonymous 

     

    below you will find a Power BI file with the unemployment figures I am working on.

    The first page has the problem with the mixed up dates, which I was showing in my

    inital message in attachment 2, and the second page has the weird time format

    of attachment 1.

    Unemployment figures 

     

    I have used matplotlib and seaborn to create the visualisations.

     

    Thanks again for your help,

    DH27