Not able to map Zero on a Line Chart for the Missing Dates

[rocky09]

I am having trouble with the mapping Zero on a line chart.  I have set of data where some of the Dates doesn't has values.  So, i have created a date table and related with each other.  But, still, I am missing the values showing on the missing months.  On the X-axis, it simply skipping the Months where there is no data.

I have already set the X-axis Type to "Categorical".

any help ?

below is the sample data. if you observe, in the Month January and February, there is no Garage Data.

Year	Month	TRIPS	TICKET_TYPE
2018	May	58	DRIVING
2018	May	15	GARAGE
2018	June	98	DRIVING
2018	June	26	GARAGE
2018	July	125	DRIVING
2018	July	40	GARAGE
2018	August	84	DRIVING
2018	August	27	GARAGE
2018	September	100	DRIVING
2018	September	10	GARAGE
2018	October	210	DRIVING
2018	October	3	GARAGE
2018	November	186	DRIVING
2018	November	1	GARAGE
2018	December	10	DRIVING
2018	December	18	GARAGE
2019	January	20	DRIVING
2019	February	62	DRIVING
2019	March	79	DRIVING
2019	March	2	GARAGE
2019	April	32	DRIVING
2019	April	2	GARAGE

[rocky09 · Accepted solution]

go it. by following this thread.

https://community.powerbi.com/t5/Desktop/Plot-zero-when-there-is-no-data-in-line-chart/m-p/585171#M2...