Forum Discussion
Line Chart – Step Change Not Clearly Visible for Small Value Differences
Hi bchappidi,
Thankyou danextian Ritaf1983, for you helpful insights.
The main issue seems to be with the data itself. In your example, there’s a noticeable difference between the two datasets, such as Test A and Test B. For Test A, the value changes over time are larger (for instance, "+2 std dev" increases from 6.63% to 11.99%), making the step changes more apparent. On the other hand, Test B shows only slight changes (like 10.34% to 10.63%), so the step line appears almost flat, even though it is still changing.
Also enable the Data Labels option in the line chart. This will display the exact values at each point, making even small changes easier to see.
Thank you.
This is a great question and a common visualization challenge. When a line chart connects two points with a small vertical difference over a long horizontal distance (like a month), the resulting slope is very gentle, hiding the intended "step."
The best way to solve this is to change the line's interpolation type from the default diagonal slope to a stepped layout.
The Best Solution: Use the "Stepped" Line Option
Power BI has a built-in feature designed for exactly this scenario. The "Stepped" layout forces the line to only use horizontal and vertical segments, creating a sharp, clear step change regardless of how small the value difference is.
Here’s how to enable it:
Select your Line Chart visual.
Go to the Format your visual pane (the paintbrush icon 🖌️).
Expand the Lines section.
Find the Stepped option and toggle it to On.
This single change will transform your smooth, sloping lines into the clear, distinct steps you're looking for, making even minor changes like the one in July 2019 for "Test B" immediately obvious.
If this explanation and solution resolve your issue, please like and accept the solution.
Why are you telling OP to do something that's already been done? If you read the post again, OP just wants the smaller changes's steps to be more visible. You clearly just copy-pasted an AI generated response without understanding the requirement or testing the response.
