Non-contin​uous line chart

[ciarangreene]

Add a setting which will allow 'gaps' in a line of there is no data present for a given X-Axis http://community.powerbi.com/t5/Desktop/Non-continuous-line-chart-data/m-p/13746

[justin_hylton]

A "render blanks as zeros" option would do the trick too

[gwp]

This is a vital feature when working with timeseries data. It can be inappropriate, misleading, and just flat out wrong to draw a line through blanks/nulls/missing values. The line suggests we know what the value was on a given date with no value, when in fact just the opposite is true - the value is blank/null/missing, there is no value, we know nothing. This can be resolved by using XY scatter, but that has its own limitations (ie no proper date axis, therefore unfriendly bordering on useless for plotting timeseries data). We really need the existing line chart to be improved as follows: 1. Option to plot values as points, lines, or points+lines (ie like excel) 2. When plotting lines, options to control what to do with missing values (interpolate, plot as 0, or don't connect - also like excel).

[vcaquilpan]

This feature is very important to show different processes. When PowerBI creates a continuos line when there is a NA or Null value, it generated a confused visualization, which could generate a misunderstanding of the behaviour of data.

[momedina]

Any update on this feature? it has been in the backlog for nearly three years. This is a very important feature that will impact many reports. Right now many of us are resorting to store zeros instead of a missing data point which is highly inappropriate. Please help us by addressing this shortcoming.

[ashish_menkudal]

Seriously, any updates?

[stephani_schupb]

I have visualizations of stream gauge data in the national parks. Having the ability to plot time-series data in a line-chart form is absolutely critical. I've tried the workarounds, but they are insufficient. Plotting a zero instead of letting the software interpolate between two data points is wrong and misleading. Our parks need the best data for their resource planning. At the very least, please find a way to allow us to change the color/symbol of interpolated data in line charts when there are no data or just don't plot it.

[mkeiper1]

Would be great to be able to have a Continuous Type x-axis for dates and this option. It would make chart look much better especially when there are a lot of different categories in the Legend

[mishal_aljohar]

I am a hydrogeologist - this feature is critical to represent water resources accurately. Thank you.

[jonwatters06]

How an organization can claim to have the premier BI tool in the industry but not even allow for gaps on a line chart is beyond me. This is like building a Ferrari but forgetting the doors.

[david_heimerlin]

Please review this. Showing a continuous line when the x axis is a date is factually incorrect. It implies there are values at the null date points when there are not. Also, it would be a great feature to also offer the null "gaps" to go to 0 rather than just show the gap.