Line and clustered column chart not showing continuous line when in between bar has zero values

[KedarnathManure]

I am trying to get lines continuos when in between value is zero. I tried sorting but still the similar result. Can someone give any idea to fix this?

[Anonymous · Accepted solution]

Hi @KedarnathManure ,

This is usually due to discontinuous axes or missing values.
If your x-axis is a date or number type, try setting the axis type to continuous.

If it is a missing value (the current result returns blank), you can try adding 0 to the end of Dax code to make the final result 0.

= <your measure> + 0

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[KedarnathManure]

@Anonymous - Thank you for the response! I don't find this setting of continuous on X-Axis on power BI desktop version I am using but <your measure>+0 really worked.

[ToddChitt]

Not sure you are going to like this answer, but I don't think you can get it in the format you have now. It looks like you are sorting by Budget Part Sales.

What is your X Axis? Is it date based (Year and Month, maybe?) Line charts really should be sorted by time.