Forum Discussion
Line and clustered column chart not showing continuous line when in between bar has zero values
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?
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> + 0Best Regards,
Gao
Community Support TeamIf 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
3 Replies
- ToddChitt
Super User
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.
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> + 0Best Regards,
Gao
Community Support TeamIf 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
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.
