Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Solid line through Scatter chart data?

Hi,

 

I often make scatter charts in excel where I add a solid line through one set of data points to show a reference the other data should be following. The first picture below shows an example of this, note the green data points and solid line following each point. 

 

Excel scatter chart

 

This whole process would be much faster using Power BI but the last step of adding a solid line through the reference data I can't do and I'd like to know if its possible? I been through the various options available in Analytics but so far nothing gives me what I want. The picture below is the Power BI version but there's no solid line following the green reference data.

 

Power BI scatter chart

 

Any help much appreciated. 

Need Help

3 Replies

  • Gordonlilj's avatar
    Gordonlilj
    Solution Sage
    6 years ago

    Hi,

     

    One thing you could try would be to add a trend line that you find under the analytics tab

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Unfortunately that doesn't work, I get an average trend line through the whole of the data. None of the other line's available in Analytics appears to work either, for what I need. 

       

      Trend line added