Re: Scatter chart with smooth lines

davidz106 · ‎05-18-2022

In my company we desperatly need a scatter chart with smooth lines option. We are able to plot out data in form of dots but would love an option to connect those dots. Any Microsoft in-house solutions on horizion? Excel can do that without any problems for more than a decade now.

I found one from pbivizedit but it comes with quite some drawbacks (no color scheme, no option to disable data labels).

cosm · ‎08-03-2023

Hi @davidz106

From the july 2023 release - smooth lines are available as a line type for line and area charts.

See release note : Release note july 2023

or the snippet from the release note below to see how you can change line type to smooth:

Kind regards!

If this solved your problem, consider marking this answer as a solution.

radhey_rec · ‎05-22-2022

Hi @davidz106 ,

It is possible to do in PBIVizEdit. Regarding drawbacks:

1. no color scheme: It is possible to define colors either programmatically or statically in the tool. Colors can be changed from Power BI too.

2. no option to disable data labels: It is possible to remove data labels altogether.

Please contact support with the exact requirements and some sample data. It should be possible what you are requesting.

Thanks.

-R

davidz106 · ‎06-23-2022

Hi, can you give me some pointers how to remove data labels from the plot (not axis) and how to apply power bi report coloring for data series (catergorical by which I mean the same that other build-in apps use)? Or is this available only as custom solution?

radhey_rec · ‎06-23-2022

Hi @davidz106 ,

1. Two ways to remove labels, either do not bind anything for Label field OR switch the label off (Visual Attributes -> plot_{index} -> Label (in the pbivizedit service and not visual).

2. I think, you are using single series and binding legend to the field. If that is correct, bind the same field with Marker color too. And then in the Marker->color-> Categorical colors. This will open Set color expression dialog. You can define your categories and colors. (Again, in pbivizedit service and not visual) Though this is limited in terms of functionality, but works for the time being.

Once you do this, export your visual. Let me know, if this works.

Thanks,

Radhey

davidz106 · ‎06-23-2022

Thanks Radhey!

First solution (remove labels) works great once I set it up online.

I still cannot work around the line colouring (I don't use Markers either). You are correct, I am using single series and binding legend to the field. Like you mentioned there is a way to define categories manually online but I guess currently there is no functionalty to use category colors from Power BI original theme, right? If I were to do it manually, I would have to define n categories and when I use this visual for different project change it again (there are 100+ sample data derived from legened field).

Ideal scenario for me would be a smooth line chart (left) but with coloring of built-in line chart in right.

Thanks in advance,

David

davidz106 · ‎05-19-2022

This doesn't solve my problem. I would need a visualization that connects the dots of scatter plot, i.e. scatter plot with smooth lines in Excel terms.

Wonder how there is a relativly low intrest in this.