cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Power-BI
New Member

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

11 REPLIES 11
cvcarubio
New Member

Hello,! The Power KPI worked in making the lines smooth or monotone.. The probem i encountered is when i publish it to wapp.powerbi workspace.. it is creating an error. the powerBi is already added in the power bi desktop but i dont see how i can add this to  app.powerbi

 

 

cvcarubio_0-1636763223288.png

 

Kolumam
Post Prodigy
Post Prodigy

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

@Kolumam  Is correct

 

When you download the "Power KPI" viz from the market place, you are going to want to edit the line by selecting 'Monotone'.  see screenshot

 

 

EricGottlieb2_0-1596045423658.png

 

Best,

Eric

samdthompson
Super User
Super User

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? 

// if this is a solution please mark as such. Kudos always appreciated.

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.

"..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.

"..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.

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

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? Mark my post as a solution!

Proud to be a Super User!




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.

Sean
Community Champion
Community Champion

If you do want this feature here you go

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

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.