Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You have a checkbox to 'include null values' in dimension of the chart properties. Kindly uncheck the same.
Thanks, already done. But this is not the cause. Any ideas?
This a chart of type "treemap" and additionally a bottom 10 is set.
try once
If( Len( [Material] )>1, [Material] )
Wonderful, many thanks!