How to create Charts with different selections for the same dimension

[#1]

I have a dimension with 4 distinct values ("Bereich") and I'd like to create one barchart for each value. However, I cannot lock the individual charts to their intended values. The only way I was able to achieve that was by "disconnecting" and changing the selection one after another:

[#2 · Accepted solution]

Did you try something like this?

For each chart, use Set Analysis to select the subset values of the Dimension:

Chart 1:

Expression: sum ({<Bereich={'1) Transport'}>} field)

Chart 2:

Expression: sum ({<Bereich={'2) SPA / WBM'}>} field)

and so on...

[jagan]

Hi,

You can use four charts with 4 different expressions like below

sum ({<DimensionName={'Value1'}>} MeasureName)

sum ({<DimensionName={'Value2'}>} MeasureName)

sum ({<DimensionName={'Value3'}>} MeasureName)

sum ({<DimensionName={'Value4'}>} MeasureName)

Hope this helps you.

Regards,

Jagan.

[anandathome]

Create 4 different bar charts with same data but edit the dimension  tab of each of them to

1. If(Dimension='Value1', Dimension)

2. If(Dimension='Value2', Dimension)

3. If(Dimension='Value3', Dimension)

4. If(Dimension='Value4', Dimension)

[#5]

You could also try using a Trellis Chart as then you will retain the same axis scale between the different possibilites.

This helps retain teh relative comparison between your 4 items.