Remove error message from Tree Map

[ronman10]

Hi Guys,

I have created a tree map showing values as well as % share of business done, country wise.  What I want is to remove the error message which is displayed below the tree map which says "* the data set contains negative or zero values which cannot be displayed." How do I get rid of this? I read in a thread (link below) that it can be removed using 'calculation condition' in Add ons. However, I am not sure how the expression would be applied in case of 0 values or negatives, including negative percentages. Any suggestions on this?

How do I show a blank when there is negative or zero value?

Best Regards,

Rony

[Mark_Little]

Hi,

Not sure of a way to just remove the message as an option.

The only way i can think of is to get rid of the message is to get rid of the zeros or negative values.

Something like

IF(Sum(Value)>0,Sum(Value))

The reason for the message is to tell you it isn't really giving you a true representation of your data.

Mark

[ronman10]

Hi Mark,

Thank you for your response.

Rony

[shephali23]

How were you able to show %share and does the chart show data points upon hover?