Combined 100% Stack an Scattered Chart

[shhafiz]

I am looking for a visual which combines a 100% stacked bar chart with a scattered chart. Here is an adapted version of my scenario:

Three column: Subject Name, Pass (Yes/No), Score

Here a subject name can appear multiple times so I am grouping by Subject Name and showing distribution of Yes/No in 100% stacked chart. I also have  separate scatter graph showing sum of scores grouped by subject name. 

Now I would like to combine these two into a single visual where Subject Name in X-axis, Pass distribution on one side of Y axis and sum of scores on other side of Y-axis.

Could anyone recommend if any such visuals exist or anything equivalent.

[v-alq-msft]

Hi, @shhafiz 

Based on my research, it is available to achieve this requirement in Power BI currently. Even if it can be achieved, the two visuals will overlap, and it will be hard to recognize. As a workaround, you can try to use combo chart , such as Line and clustered column chart or Line and stacked column chart, see more : https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-combo-chart.

Best Regards,

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.