Add Filtered Column Values from the Same Column to a Stacked Column Chart

[gmayshark]

I am trying to find a way to view a stacked column chart by its constituent filters. For example, I would like to view the requisitions per business unit of my organization, but then view the status of each requisiton ("Filled", "Accepted", "On hold", or "Sourcing") as a stacked column, where each stack is a status. The issue being, since all the values for the status filters come from the same column, I cant figure out a way to add each individual status to the column values. Please let me know your thoughts.

[v-piga-msft]

Hi @gmayshark,

The issue being, since all the values for the status filters come from the same column, I cant figure out a way to add each individual status to the column values. Please let me know your thoughts. 

It seems that you want to create a stack column chart and use the status as the x axis, but I'm still a little confused about your scenario.

If it is convenient, could you share your data sample which could reproduce the scenario and your desired output so that we could help further on it.

Best  Regards,

Cherry