Legend issue in Stacked column chart

[sagarsharma12]

We are doing Migration from Qlik Sense to Power BI.

There is one Bar chart in Qlik Sense which has columns and measures assigned as below

X-axis: Month

Bar: BU/RU (These both columns are in Drilldown)

Measures: No. of Approved Values

In Power BI, we are using Stacked column chart for this.

X-axis: Month

Y-axis: No. of Approved Values

In Legend section we are supposed to put BU/RU, but Legend section does not allow to put two columns inside it.

We even tried with Hierarchy but Hierarchy is also taking only 1st column not second one.

If anyone gets any workaround for this, it will be really helpful.

@PowerBI

[v-yanjiang-msft]

Hi @sagarsharma12 ,

Was your problem resolved? If so, please kindly mark the helpful reply as solution, then we will close the thread. People with the same problem will benefit here.

Best regards,

Community Support  Team_yanjiang

[v-yanjiang-msft · Accepted solution]

Hi @sagarsharma12 ，

According to your description, I suggest you put Month, BU and RU in X-axis at the same time.

As drilling down, the visual varys as below:

 

I attach my sample below for your reference.

Best regards,

Community Support Team_yanjiang

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