cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Power-BI Frequent Visitor
Frequent Visitor

Smooth lines

Is there any way to smooth lines on a line chart?

 

I'd like it to flow more like this one made in Excel, than the one below it made in PBI.

Capture.JPG

Capture2.JPG

 

Many thanks

9 REPLIES 9
samdthompson Established Member
Established Member

Re: Smooth lines

hi. there is not a way to do this in powerbi that i am aware of. 

 

I know that the smoothed line looks good but is it an accurate representation of the data? 

unclejemima Member
Member

Re: Smooth lines

This was a while back...any chance this is possible in new version?

KHorseman Super Contributor
Super Contributor

Re: Smooth lines

Seems like a terrible idea anyway. In that example picture the curves make the lines go higher and lower than the actual data points they're connecting. So the graph is lying. It looks pretty but it's worse than useless for representing data. It's a good thing that we don't have this "feature".


Did I answer your question? Please mark it as a solution.

Proud to be a Datanaut!
Sean Super Contributor
Super Contributor

Re: Smooth lines

If you do want this feature here you go

https://zoomcharts.com/en/microsoft-power-bi-custom-visuals/

Highlighted
dobermanne Frequent Visitor
Frequent Visitor

Re: Smooth lines

"..is it an accurate representation of the data?" - it can well be more accurate than showing only the measured points..

 

In case the data in question is anyway an estimate and contains error, representing absolute points instead of smooth lines indicating that "it is roughly like X" is totally and utterly warranted in my opinion. Also, for cases where you have continous phenomenon underneath (such as temperature...) but have only discontinuous measurements (say hourly), again, smoothing the lines to be continuous more truly represents the underlying distribution, of which the collected data is only a partly representing sample. I disagree with your stance for many a dataset of reality.

dobermanne Frequent Visitor
Frequent Visitor

Re: Smooth lines

"..is it an accurate representation of the data?" - it can often well be more accurate than showing only the measured points..

 

In case the data in question is anyway an estimate and contains error, representing smooth lines instead of absolute points only indicating that "it is roughly like X" is totally and utterly warranted in my opinion, being more truthful representation of the data. Also, for cases where you have continous phenomenon underneath (such as temperature...) but have only discontinuous measurements (say hourly), again, smoothing the lines to be continuous more truly represents the underlying distribution, of which the collected data is only a partly representing sample. I disagree with your stance for many a dataset of reality.

dobermanne Frequent Visitor
Frequent Visitor

Re: Smooth lines

In case the smooth lines would go over or under the actual observed values, yes, wrong, but in case they remain within the observed boundaries, result may well represent reality better than discontinuous observations of a phenomenon. Think of temperature and hourly measurements of it. Cheers.

mussol_ Regular Visitor
Regular Visitor

Re: Smooth lines

If you want to represent a "Gauss Bell", it is completely necessary to have smooth lines to understand the distribution.

That's because i think it is necessary to have the possibility to represent a smooth line chart.

Josep.

Kolumam Member
Member

Re: Smooth lines

Hi All,

 

The below visual offers the same functionality of smoothing as that in excel.

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381083?tab=Overview

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 334 members 3,203 guests
Please welcome our newest community members: