Column chart with total like a container chart

[Anonymous]

Hi,

I want to create a chart like shown below. It has individual column chart and also total chart with dotted line inside which individual column chart is displayed.

How can we create this visual in Power BI?

Link to YouTube video for creating this using Excel - https://www.youtube.com/watch?v=Gcn0FW9nZMA