Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

All dates in chart

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

  • hi, Anonymous 

    You could get it just by adjust measure like this:

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

    For example:

    BeforeAfter

    Best Regards,

    Lin

1 Reply

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support

    hi, Anonymous 

    You could get it just by adjust measure like this:

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

    For example:

    BeforeAfter

    Best Regards,

    Lin