Displaying not null expressions in chart

[Matt]

Hi,

I have a simple pie chart with no dimensions, only expressions. Each of them is calculated, f.e. like this (just diff status)

COUNT({<[Status]={'Finished'}>} DISTINCT [Contract])

On few statuses I get zero values in the legend (count = 0)

How can I display only not null values in the legend?

Presentation tab -> suppress missing/zero-values is not working.

Thanks.

Regards,

M.

[anushree1]

Tick on Suppress when Value is Null in Dimensions Tab 

[Matt]

Not available, since there are no dimenions to select

[martinpohl · Accepted solution]

Use Expression condition to Show, see example

Regards

[Matt]

Thank you Martin.

I was putting >0 into ()...

Have a nice day!