Visual Calendar missing November and December data (?)

[Anonymous]

When setting the months of November or December, the values are not shown in the component. For other months Jan to Oct are fine.

Probably the bug:

Using different months rather then November and December:

[v-cherch-msft]

Hi @Anonymous

I cannot reproduce the same issue.Could you share the .pbix for us to test?You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.

Regards,

Cherie

[Anonymous]

Sure.

https://drive.google.com/open?id=1yJjZO-raDqcShhYmv-WXo96alIu0rWi7

[v-cherch-msft]

Hi @Anonymous

Based on my test,it seems you may set the correct locale for your data and make sure the date column has no error in query editor.

Regards,

Cherie

[Anonymous]

Still not working at my side.

I did what you say, change the local settings to English (Samoa), not worked. Changed do Portuguese Brazil, neither.

When I opened your file, is the same problem.

Try to change your local settings from your laptop to Portuguese Brazil, in order to simulate the same conditions.

If you want, I can share a remote connection to check my environment.

[v-cherch-msft]

Hi @Anonymous

It's difficulty for me to reproduce your scenario.Please try to check the below settings for your PC and desktop:

1.The region of PC is the same as desktop

2.Locale for import of desktop is Portuguese Brazil

3.Check the date column in query editor and make sure there's no error in it.

Regards,

Cherie

[Anonymous]

For all other visual components, the date is recognized, with no problems. Since the first visualization.

It seems to be a bug with non US date system.

I need to change the visual component due to that restriction in my project.

Thanks for your efforts, but no solution at all.

[Andre_Jaar]

Michel,

to "solve" this problem, you can add a text "date" column

= Table.AddColumn(#"adding Text Date", "DateText", each Text.From([Date]))

The bug happens when you convert the column to Date. 

so, for report showing i use the text column...