March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Currently the line chart "step" line type will change values half way between each data point which tricks the eye into thinking a value changed at a specific point in time, when it didn't.
A "step after" interpolation mode should be implemented so that the value of the first data point is held until the value of the second data point. This issue is discussed in these two community threads:
1) https://community.fabric.microsoft.com/t5/Desktop/discrete-graph-step-chart/td-p/1842169
I use line charts to show trends, and compare values between trends. Linear interpolation between points might be helpful in some use cases but comparing between interpolated values is often useless when your data is relatively sparse and especially when your data points are not aligned in time (so you end up comparing a real data point to an interpolated data point).
Most other BI / visualisation tools have a "step after" interpolation mode where the value of a point is held until the next data point.
Work arounds include things like creating date spines (causes issues with knowing which points are reall data points), using line charts (and making the comparisons inacrruate), or using bar charts (making comaprisons between points in time difficult).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.