Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
rocky09
Solution Sage
Solution Sage

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

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.

YearMonthTRIPSTICKET_TYPE
2018May58DRIVING
2018May15GARAGE
2018June98DRIVING
2018June26GARAGE
2018July125DRIVING
2018July40GARAGE
2018August84DRIVING
2018August27GARAGE
2018September100DRIVING
2018September10GARAGE
2018October210DRIVING
2018October3GARAGE
2018November186DRIVING
2018November1GARAGE
2018December10DRIVING
2018December18GARAGE
2019January20DRIVING
2019February62DRIVING
2019March79DRIVING
2019March2GARAGE
2019April32DRIVING
2019April2GARAGE

 

1 ACCEPTED SOLUTION
1 REPLY 1
rocky09
Solution Sage
Solution Sage

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors