Scatter plot for penetration w/expected growth line

[Gstone216]

We have a chart in excel that works great, but requires more manual update that is gradually falling further behind. It is a scatter plot and a line. The line indicates our growth curve (expected growth) and the scatter plot marks indicate actual performance by the market. Markets vary on the plot map based on length of active service (the numeric numbers at the top of the data). In an attempt to automate some move this into BI platforms we have not found the right way to organize the data to allow us to create/duplicate the chart. Any help?? Below are pictures of the chart in excel and the data layout we currently use in excel. This is a sample as we actually have 100s of markets and not 8. 

 

 

[lbendlin]

Have you considered using Deneb?

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...