Barchart - each bar is a subset of the previous one

[newpbiuser01]

Hello,

I'm trying to create a bar chart where each bar on the chart gets filtered down, so that each bar is a sub-set of the previous one. 

As an example, if I have a table as follows:

Type	Color	Name	Quantity
Fruit	Red	Apple	44
Fruit	Yellow	Banana	42
Fruit	Green	Grape	21
Fruit	Orance	Orange	10
Fruit	Yellow	Mango	27
Fruit	Green	Kiwi	37
Fruit	Yellow	Pineapple	47
Fruit	Red	Strawberry	28
Vegetable	Orange	Carrot	21
Vegetable	Green	Cucumber	42
Vegetable	Yellow	Potato	31
Vegetable	Red	Onion	23
Vegetable	Green	Spinach	13

I am trying to generate a graph like this:

How could I generate something like this? I'd really appreciate any help.

[vicky_]

Does it have to be a column chart? Maybe a visual like the decomposition tree would better suit your needs.

[newpbiuser01 · Accepted solution]

Hi @vicky_ ,

Unfortunately it needs to be a bar chart. I figured it out though. I created a calculated table where each row was summarize based on the color, type, name and then use those.