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.
Hו bchappidi
If the goal is just to show that there was some change maybe the line chart is not a most effective way..
Try to check the heat map option ...with shorter perioiod something like the heat map in my blog post:
https://community.fabric.microsoft.com/t5/Power-BI-Community-Blog/When-to-Use-Heatmaps-and-How-to-Implement-Row-Level-Heatmaps-in/ba-p/3929725
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Thanks for the suggestion! I understand your point about using a heat map.
However, in this case, the users specifically prefer a line chart, as it aligns with the format they’re already familiar with in their existing spreadsheet. They’d like to maintain the same visual style for consistency and easier comparison.
Also, some portfolios have data spanning from 2005 to 2025, and with a line chart, it’s much easier for them to spot step changes across such a long time frame.