Forum Discussion
Anonymous
7 years agoNot applicable
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-msftCommunity 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