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 (23)
RE: Non-continuous line chart
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.
RE: Non-continuous line chart
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).
RE: Non-continuous line chart
A "render blanks as zeros" option would do the trick too