How to hide column for no values

[ashis]

Hi ,

I have a straight table where it has job names and its ancestor job names . Please see the image attached.

As dimensions , I have taken combination of jobs and its ancestor and all the parents.

There are scenario where one job has only two ancestor or only one ancestor . In that case I do not want to show all the parents in the chart .

In the below scenario I want to hide Parent2 , Parent3 and Parent4 since there is no value for SSIS1 JOB .

I am struggling to hide it,

Any suggestion on how to do it.

[Siva_Sankar]

Hi Ashis,

Find the attached example, you may use condition expression as shown in screenshot.

[ashis]

Hi Sivasankar,

Thank you for your quick reply . I have tried out this solution earlier, however it did not work.

If you see in my data I have null values , when I bring it as expression. The problem is when we say

=IF(IsNull(Parent1),0,1) , what is happening in  the first row Parent1 has one null value hence it is hiding this column as well.

Where as I want to hide only those columns where there is no value or all null values in one column.