Hide certain values in chart

[#1]

I'd like to hide certain values depending on the value of the expression that is chose. I want to display the value in the expression so that other dimensions in the chart will be displayed. I just want one dimension for certain values to display as null. I'm not sure where to begin.

[Qrishna]

post some sample data.

[#3]

In the Risk Summary Report chart I would like to hide the value in the % Files Reviewed dimension if the value of the Doc Type is "ASN" or "END".

[phaneendra_kunc]

you have two options. See attached.

Option 1:

=if(wildmatch([Doc Type],'ASN','END'),' ',

[Loan Count]/Count({1<[WeekEnding], [Pool] = {'$(vPool)'}>}[Loan ID]))

Option 2:

=[Loan Count]/Count({1<[WeekEnding],[Doc Type]-={'ASN','END'},[Pool] = {'$(vPool)'}>}[Loan ID])

[Qrishna]

If you want to hide the column '% Files Reviewed' upon selecting 'ASN' or 'END' from 'Doc Type', see attached.