Your expected chart output is a combination of stacked column chart and scatter chart. However, this is not a supported chart type in Power BI desktop. So, I'm afraid your requirement cannot be achieved currently.
You can sumbit your request at this page: How can we improve Power BI?If this feature was mentioned by many users, product team will consider to add this feature to next release.
Best regards, Yuliana Gu
Community Support Team _ Yuliana Gu If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.