Forum Discussion
Scatter plot for penetration w/expected growth line
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.
1 Reply
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-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
