6 Replies Latest reply on Sep 15, 2018 3:21 PM by Ken Flerlage

    How to Hide a measure mark if it has all null values?

    Rahul Sharma



      In my sheet I am using multiple axis and all the measure have different Y axis but same X axis (Measure are on row shelf ). How to hide a measure mark if that measure has null values for all that.


      In the attachment I want to hide me 2 and me 3 mark as they have null values as of now.



      I can show them in different sheets and then hide the sheets based on NULL value filter. But if they are all on same sheet I will not be able as that null value filter will effect other measure line graph also.

      Please help in this if any workaround possible.