Need Help: Issue with Date format when publishing to Power BI Service

[alalan]

Hi Folks,

I need your brain to resolve an issue which is going on since long-time now and even MS support team couldn't help. 

I have 3 measures which are counting the total number of active employees, total number of terminated employees and subtraction of active and terminated employees to give nett active employees in the selected date range. 

The issue:

When using the measure in power bi desktop environment, the visual display correct calculations and when I publish it to the Power BI service, these visual go blank. 

After lot of attempts of troubleshoot the issue, it is identified that date format is playing up. 

I want your brains to resolve this issue. 

Thanks in advance.

Measure - Subtraction Active and TerminatedPower BI desktop visualPower Bi Service visualMeasure - Total Active employeesMeasure - Total Terminated employees

[alalan]

@v-luwang-msft 
I followed the steps as mentioned in the blog, still my power bi service time zone is not changing to AEST.
Am I missing something?

[v-luwang-msft]

Hi @alalan ,

It may be a date conversion issue, because your Desktop uses a different locale than the service. You may try to do the date conversion with a specific locale. Check this: https://www.excelguru.ca/blog/2015/07/08/fix-date-errors/

Best Regards

Lucien