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
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
RE: Non-continuous line chart
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.
RE: Non-continuous line chart
Seriously, any updates?
RE: Non-continuous line chart
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.
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