Forum Discussion

davidz106's avatar
davidz106
Icon for Helper III rankHelper III
4 years ago

Scatter chart with smooth lines

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

Need Help

8 Replies

  • radhey_rec's avatar
    radhey_rec
    Icon for Resolver II rankResolver II
    4 years ago

    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's avatar
      davidz106
      Icon for Helper III rankHelper III
      4 years ago

      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's avatar
        radhey_rec
        Icon for Resolver II rankResolver II
        4 years ago

        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's avatar
    davidz106
    Icon for Helper III rankHelper III
    4 years ago

    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. 

    • KerKol's avatar
      KerKol
      Icon for Power Participant rankPower Participant
      4 years ago

      Are you trying to connect the dots or draw a line of best fit?

       

       

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.