100% stacked bar - 2 columns on legend in one visual?

[Dmit]

There is a post already (here) but seems no solution. I have 2 columns with categories data and 1 column with value as follows:

data

Below are 2 visuals that i need to have as one visual, basically having multiple columns in legend which seems not possible in PowerBI. is there any workaround?

have both bars on one visual?

[MFelix · Accepted solution]

Hi @Dmit,

To get this type of visual on the same graph you need first of all unpivot column 1 and column 2 then you will get two other columns Attribute and Value then setup your chart with the following way:

Visual: 100% Stacked Bar Chart

Axis: Attribute

Legend: Value column

Value: Value

Then just setup the colours as you like:

Regards,

MFelix

[Dmit]

Thank you very much @MFelix. It is very simple and it resolves