Add 2 lines in one chart of power BI same like excel scatter chart

[Nivedhana]

We have 2 tables and we need to create a chart in power BI with 2 different lines. One for the actual table 1 and one as a reference line with data from table 2. How can we achieve this using power BI? 

[lbendlin]

You use a dimension table with your speeds, and then add the values from your two fact tables.

[Nivedhana]

@lbendlin Thank you very much! This works for line charts whereas what we are looking for is to have a scatter chart and plot most relavant power curves or polynomial curve across the scatter and see the equation behind the chart. 

[lbendlin]

Drawing Beziers and showing the formula is not something you can do in Power BI default visuals. Look into SVG, or custom visuals.

Or, keep using Excel.

[Nivedhana]

Thank you @lbendlin , we are looking into python visuals and creating the same with it.