cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Postigo Regular Visitor
Regular Visitor

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 

 

 

PowerBi.jpg

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: All dates in chart

hi, @Postigo 

You could get it just by adjust measure like this:

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

For example:

9.JPGBefore10.JPGAfter

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

Re: All dates in chart

hi, @Postigo 

You could get it just by adjust measure like this:

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

For example:

9.JPGBefore10.JPGAfter

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.