Ciaran Greene on 06 Jan 2016 17:02:24
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
- Comments (17)
RE: Non-continuous line chart
After 4 years, no news. What a pitty
RE: Non-continuous line chart
We are displaying timeseries data from our machines and this is needed for us to analyze the data when we have gaps.
RE: Non-continuous line chart
I need this too for my chart
RE: Non-continuous line chart
Very much would like to see the option for non-continuous lines in a chart. Like others have said, it is misleading to show a line where there is no data.
Thanks!
RE: Non-continuous line chart
Come on, this is a critical feature. It is misleading to interpolate lines where there is no data. Please allow gaps to be shown in continuous line charts.
RE: Non-continuous line chart
Any update on this? it's been more than 3 years...
RE: Non-continuous line chart
Others have mentioned the option of replacing null values with zero. An extension to this would be to allow the user to define a custom replacement value (potentially per series).
Another option that would solve the problem would be to display a broken line, by switching off line interpolation when there are discontinuities in the data.
RE: Non-continuous line chart
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.
RE: Non-continuous line chart
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.
RE: Non-continuous line chart
I am a hydrogeologist - this feature is critical to represent water resources accurately. Thank you.