Forum Discussion

alalan's avatar
alalan
Frequent Visitor
4 years ago

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

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

 

2 Replies