Forum Discussion
Legend issue in Stacked column chart
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.
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.
2 Replies
v-yanjiang-msftCommunity Support
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.
- 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