Multiple colors in clustered column chart

[AlmantasPBIguy]

Hey, power people, 

I want to make a column chart, that has 8 colours divided in 4 groups, in a clustered column chart,  with 2 dimentions in the legend. 

Should look something like this: 

As I understand clustered column chart does not have this as a standdard option. Can it be done?

[amitchandak]

@AlmantasPBIguy , with 2 measures or legend you can not use conditional formatting, you need to manually choose color.

With Axis(2 columns) and single measure you can

example

Concatenate Label off : https://youtu.be/QgI0vIGIOOk