Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
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
Have you checked 'Suppress When Value is Null' on the dimension tab? If not do that and null dimensions should be removed.