How to fix the new misleading default line chart swoopiness in Power BI.
Hey you. Let’s fix some bad Microsoft formatting
Every month, Microsoft tweaks Power BI… and most of the time they are adjusting the data side of things (new ways to connect to data, etc), and to be frank, get YOU wrapped up into their data ecosystem (which you do NOT need to be, so don’t drink the koolaid).
Recently, they’ve been tweaking the default formatting that charts have when you make them, and y’all, it’s NOT good. It is formatting that adds clutter and makes data HARDER to understand.
What the hell, Microsoft?

We’re going to fix one of these in this post, namely (as you can tell by the title of this post) the new misleading “swoopiness” (or interpolation, if you want to get all technical on me) default line style on Line Charts.
If you want to use the same Power BI file I use in the video below (and the screenshots in the written summary below), here’s the pbix file to download. You can also click the graphic below to get it.

Video Instructions:
Written Instructions:
Let’s have a look at the simple Power BI line chart I’ve setup to demonstrate what’s happening with Line Chart line styles now.

Oooh, look. It’s a swoopy line chart. So pretty right?
Yeah, it IS pretty, and sometimes you definitely might like to have swoopy lines in your line chart. That’s no problem.
The problem is that this is now the DEFAULT formatting for any and all line charts you make, and previously you could turn on that swoopyness. Now you’re stuck with it from the get-go.
The issue with swoopy lines is they visualize data that is NOT there. The swoopy lines basically interpolate data (geek talk: Interpolation is the practice of inferring unknown values from known ones), making it seem like something is happening that isn’t.
Let’s see how this affects our line chart by looking at the lines between 2023 and 2024. I’ll go into our formatting options and turn on data markers so you can see exactly where those data points are.

Let’s use that light blue line as an example. With the line swooped / interpolated like it is, it appears to your viewer as the value started decreasing slowly early in 2023, then sped up and dropped faster through the mid-point of the year, and slowed again before the start of 2024.
This is NOT what is in our data. Our data has one number for each year. There are no “data midpoints”. A viewer, if not familiar with what data makes up this chart (which is unreasonable to expect if they aren’t the person who made this chart or at least a data analyst familiar with the data) would understandably infer that there are varying rates of change between each data point.
Microsoft, this is garbage default formatting.
This is an example of a method that makes a chart look “pretty” that is at best a disservice to your dashboard viewers, and at worst, misleading / lying to them.
A viewer should NOT have to click around a simple line chart to discover that there is actually only one data point per year.
To change this to what SHOULD be the default formatting, go into your Visual Formatting options in the Visualizations Pane, and open up the Lines section.
Then go to the Interpolation Type dropdown and change it from Smooth to Linear.


Much better.
This isn’t to say that interpolation / swoopiness should never be used.. but it should NOT be the default formatting.
Take care everyone,
Joe.
More Hot Tips!
Posts about Formatting
Like these posts but need more formal (but still engaging and fun) training in Power BI? Contact me, Joe Travers or at joe@traversdata.com. I got you.

Contact Joe | TraversData.com | People-Friendly Power BI | LinkedIn