Dynamically change the stacked bars

[wmalgal]

Hi All,

Im new to Power BI.  I am trying to set up a stacked bar chart as shown above.  So thats number of people hired (offers accepted) per month and the stacked bars show the break down per busines unit.

Is there a way of having a selection box where i can say.. ok show same data but i want the stacked bars broken down by gender hired not by business unit?

Hope ive been clear enough.

Thanks,

A.

[v-yulgu-msft · Accepted solution]

Hi @wmalgal,

If I understanding correctly, you want to dynamically switch the legend between [Business Unit] and [Gender] in this stacked bar chart via a selection box, right?

However, this is not a supported feature. To work around your requirement, you can add [Gender] and [Date] fields to axis, add [Business Unit] field to legend. When you want to see details about Gender, click the highlighted down arrow to drilldown the chart.

Best regards,
Yuliana Gu

[wmalgal]

Thanks for this - really appreciated!