All dates in chart

[Anonymous]

Hi, i have a problem. I have two tables (dTime = with all the days and months until 2025, and fOrder with all my data)

Im doing a line chart where i put dTime[Date] in the axis and a fOrder[NumberofOrders] in value, but the problem is, i need to show every single month in this chart(put zero in the months that doesnt exist).

As a example, must appear march,april, june and july with 0 in the chart 

Thanks

[v-lili6-msft · Accepted solution]

hi, @Anonymous 

You could get it just by adjust measure like this:

Measure = CALCULATE(SUM(fOrder[Value]))+0

For example:

BeforeAfter

Best Regards,

Lin