How to show different measurements as stacked bars?

[nenadvukovic]

I need to show 3 groups of 3 measures for each year as stacked bars. Is something like this possible using bars not symbols?

Thanks 

[rubenmarin]

Hi @nenadvukovic, if you create a bar chart with 2 dimensions and more than one measure it creates that kind of chart by defaut. You can also disable the legend for 2nd dimension to show tham more like your example:

[nenadvukovic]

Thanks Ruben. I had to re-develop the data model for that to work as required.

[nenadvukovic]

Sorry, it was a premature conclusion that this would work. Can you use my data in your qvw? The point is to group two main measures for each Year

Thanks

[rubenmarin]

I can try... can you post your data as text?

But I used something that is somewhat similar (attached)

[nenadvukovic]

If that would not be possible with standard properties, I believe that I will need to create dummy Year by adding suffixes to create groups I want to show for each year. Agree?

[rubenmarin]

Have you checked my last attachment? it's like the example, it only needs to apply colors.

It has only one masure, and 3 dimensions, one of them calculated to split each year in 3 bars

[nenadvukovic]

Yes, I did. I've updated your qvw with my data from the initial screenshot and sent it in my previous post. I believe this is not possible to achieve without changing the data model.

[rubenmarin]

If you check my qvw, it also has your data, and it shows as your original example without the need of changing the model. Maybe you can create a field instead of using the calculated dimension but no more changes are needed.

[nenadvukovic]

The point is, as I was expecting would be clear from the initial screen shot to group bars by several dim2 values. I tried to color-code thos for easier understanding of the request. So, all Ps to be shown as one stacjed bar for each year, then all Cs, etc.,