Please help me produce the same chart?

[Anonymous]

I need to produc something similar to this: https://www.defteam.com/stacked-clustered-bar-chart/

any idea how can I do it?

Thanks

[MFelix]

Hi @Anonymous ,

Using the default Stacked Column chart you can get a similar chart only difference is that the countries are also placed at the bottom.

Be aware that you need to have a trick to have the working categories concatenated that is sorting the values by country

check PBIX file attach

[mwitting]

Hi @MFelix  ,

The standard chart does not provide the ability to create a cluster of measures in the same group. I think this is only achievable with the custom visuals!

[MFelix · Accepted solution]

Hi @mwitting ,

You are saying the the forecast and actuals are measure values?

That is possivle uaing a disconnected table and a SWITCH measure.

[Mwitting1]

@MFelix  you are right, they are not measures. Your solution works 🙂

[MFelix]

@Mwitting1 ,

👍.

Please don't forget to mark the correct answer so it can help others.

[Anonymous]

Hi @Anonymous 

Have you tried using the Stacked Column Chart by Akvelon? To import a Power BI visual, in the Visualization pane click Get more visuals. 

Hope this helps 🙂