Hide irrelevant secondary dimension values in bar chart

[svanderwerf]

Hi Everyone,

I want to create a bar chart which has two dimensions. The dimension value of the second dimension should be grouped within the corresponding first dimension value. I succeeded in creating a chart which does that:

As you can see, I have different kinds of fruit, grouped by color.

How can I hide the irrelevant values of the second dimension. I want to show the group 'Blue' which only contains the number of 'Grapes', the group 'Red', which contains the number of Cherries and Tomatoes, and finally the group yellow which only contains the number of Apples and Bananas (so no cherries, grapes or tomatoes here).

Is this possible?

My .qvw is attached.

Thanks!

[tresesco]

This is possible in pivot/straight table chart and unfortunately not in bar chart.