Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Plot zero when there is no data in line chart

Month = month('Shiptracking history'[Date]) year = year('Shiptracking history'[Date]) MovingAverage = calculate(sum('Shiptracking history'[Production+0]),DATESINPERIOD('Shiptracking history'[Date],...
Need Help
v-cherch-msft's avatar
v-cherch-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi Anonymous

 

You may try to replace the null value with "0" in query editor.

 

Regards,

Cherie

Anonymous's avatar
Anonymous
Not applicable
8 years ago

v-cherch-msft thanks, it didn't work. I have provided more details in my post, in case that is helpful