Dynamic Bar Chart Axis

[cloud]

Hi all,

I have Type A and Type B in the pivot table and a barchart.

Type A only display integers 

Type B only displays percentage

How can I set it such that when I click on Type A, the barchart axis shows integers but when I click on Type B, the barchart axis shows percentage. Dynamically changing axis based on what the type displays. 

Any help is appreciated! thanks  

[Vegar]

Assuming that Type A and Type B are values in a dimension you could do this.

Create two bar chart expressions, the integer expression and the percentage expression.

In the conditional show for the expressions type this. 

SubStringCount( Concat( DISTINCT '|' & YourTypesField & '|'), '|Type B|') = 1 

or

SubStringCount( Concat( DISTINCT '|' & YourTypesField & '|'), '|Type A|') = 1