Forum Discussion
Line Chart appears non-continuous
Hi peternguyen2 ,
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.Please show the expected outcome based on the sample data you provided.
How to provide sample data in the Power BI Forum - Microsoft Fabric CommunityRegards,
Harshitha.
peternguyen2 Hello,
Kindly follow below steps to resolve your issue.
STep 1 - If you're using a measure then you can use COALESCE or IF Logic.
example -
samplemeasure = COALESCE(SUM(OrderWeight[NetWeight]), 0)
this will avoid gap in your data and it will auto fill 0 in case of missing value.
STep 2- Change in chart setting
format -> x axis setting -> show item with no data to on
Set Type to Categorical instead of Continuous
Thanks
Harish KM
Please accept this as a solution if this solves your problem and give kudos as well.
Thank you for your solution. I have tried by did not work