Dimension without value -> don't show

[TomBond77]

Hi experts

I have a dimension "material" and one measure. There are a few records without a value on dimension "material". I have chosen a treemap as chart. Unfortunately these records are shown too on that chart. I have the following expression on this dimension:  =If(not(IsNull([Material])), [Material], Null())

But it is not working. 

Do you have an idea how to deselect these records?

Many thanks

Tom

[Jayavignesh]

You have a checkbox to 'include null values' in dimension of the chart properties. Kindly uncheck the same.

[TomBond77]

Thanks, already done. But this is not the cause. Any ideas?

[TomBond77]

This a chart of type "treemap" and additionally a bottom 10 is set.

[NitinK7 · Accepted solution]

try once

If( Len( [Material] )>1, [Material] )

[TomBond77]

Wonderful, many thanks!