Filter Dimension wrt Measure

[#1]

Hi,

I have a bar chart where one dimension and two measures available. For some values or selection one of the measure value going 0 or zero but I don't want to show those set of bars where one of the two measure value is 0.

i want to remove those values on axis which contains 0 value by default or after selection.

I am attaching two snapshots which cal clarify both cases stated above.

[sunny_talwar]

May be something like this:

Change Expression1 to this -> If(RangeMin(Expression1, Expression2) > 0, Expression1)

Change Expression2 to this -> If(RangeMin(Expression1, Expression2) > 0, Expression2)

[#3]

Hi Sunny,

Thanks for your comment, yes its working almost fine , Just one concern left that , measure are perfectly filtering but the dimension values who has null measure also coming on the axis . Can you please help me in this

[sunny_talwar]

Have you checked 'Suppress When Value is Null' on the dimension tab? If not do that and null dimensions should be removed.