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

[DH27]

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 if I convert the data to text in the query-editor, the order is getting disrupted (attachment 2).

In the query-editor, my data remains in the correct order and looks fine. 

Any help regarding this problem would be very much appreciated!

Attachment 1Attachment 2Attachment 3

[DH27 · Accepted solution]

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.

[v-jayw-msft]

Hi @DH27 ,

What's the data type of monat_1 column in Attachment 3? 

Do we have sort by feature in the visual?

Best Regards,

Jay

[DH27]

Hi @v-jayw-msft 

thanks for your comment, the data type is text.

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

[v-jayw-msft]

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]

Hi @v-jayw-msft 

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