Clustered Column Chart shows Specific Values depending on Axis (Drilldown)

[Anonymous]

Hello all,

Pretty straightforward, as the title says, I'd like to show some values depending on the axis I'm in on a clustered column chart. 

For example, if I have "Axis 1", "Axis 2" and "Axis 3" to use Drilldown with the Values "Value 1", "Value 2" and "Value 3", is it possible for example to show Values 1, 2 and 3 on Axis 1 and 2 but only Values 1 and 2 on Axis 3?

Thank you.

[TeigeGao]

Hi @Anonymous ,

Could you please share some sample data and expected result to us for analysis? You can share an image of your expected result.

Best Regards,

Teige

[Anonymous]

Hello @TeigeGao and others,

Example below.

As you can see, I have a Clustered Column Chart, with 4 Axis and 2 Values, for example.

In Axis 1, everything is ok.

If I drill down to Axis 2 in one of the values from Axis 2, everything is still ok.

When I drill down to Axis 3, the orange value doesn't make sense anymore, because I cannot differentiate it in the Axis 3 categories, so I get 4.8 for both (the same 4.8 in the 5th column set)

I wanted a way to define which values (columns) are going to appear in each drill down level (axis) so in Axis 3 I would show only the gray value because the orange value because it is redundant.

Hope it is clearer now.

tks