Forum Discussion
rocky09
Solution Sage
Solution SageLine and Clustered Column chart - No Continued line
See below image, I am not sure, why the line is continued, it breaks on August Month and again started in December. Can any one advise or share the tips, how to get rid of this issue, I would like to...
v-yuta-msft
Community Support
Community SupportHi rocky09,
Based on the chart you provided, values of [No. of Errors] are null in several months, right?
To achieve a continued line, you should replace null with 0 in Query Editor.
The result is like below and you can refer to PBIX file here:
https://www.dropbox.com/s/uq55jklv0b0oi3y/For%20rocky09.pbix?dl=0
Best Regards,
Jimmy Tao
rocky09Solution Sage
Solution SageThank you so much for your time and reply.
1. Actually, I have date table and data table.
2. The Date table is from January 1, 2017 to today.
3. The Data table may not have entries for a month.
So, When I use Date from Data table as X-axis and Data values from Data Table. It seems, the line breaks when there is no data for a month.