Showing items within group in a legend (stacked column chart)

[m_chan]

I am trying to build the following stacked column chart:

• the stacked bars (associated with the legend) are for categories I have custom grouped - 3 groups = 3 differently colored blocks
• the legend showcases what group is associated with each of the 3 colored blocks, however also lists out the individual items that are within each of the custom groups I had created

Is this possible to do? Thank you

[Daniel29195]

@m_chan 

it would be helpful if you can show your desired output, 

[m_chan]

Thank you. Below is an example of a sample data set I threw together - would it be possible to list out all the Clothing Types shown in the legend of the left-hand graph (ie: button up, dress pants, etc.) underneath the respective group they belong to in the right-hand graph? The last screenshot shows what clothing types are within each group.

[Daniel29195]

@m_chan 

To be able to achieve what you want, you need to be able to add 2 columns in the legend which is not simething you can do in power bi . 

one possible option maybe, to create a concatenated column as : 

new column = table_name[clothing_type_groups] & " - " & table_name[clothing_type]

and use it as a legend . 

another option is using a custom visual : like this one .

third option would be : adding both columns to the X-axis.

and enable the drilldown option ( circled in red ) , 

this way when you click on a group  it automatically goes to the second level .

let me know if these are possible solutions for you. 

If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. Dont forget to hit that  thumbs up button 🫡👍