Filter the chart type based on condition (in other work Pie if +, bar if any - value

[#1]

Hi,

I'm looking for a way to display the right chart type based on value.

I've defined a chart which is either on bar or pie but I would like the pie to be excluded (so bar display) when I have negative value

Is this possible?

Thanks for your help

[#2]

You can use conditional layouts.  See attached.

[#3]

Thanks Rebecca. I undertand your example but cannot replicate it on my data.

I don't know which dimension (other than my sum) I should check as the user can select any...

My expression in my graph is sum([Rev.Amount rev])....

I tried =if((Min([Rev.Amount rev]))<0,0) but the condition is always on so I cannot see the graph....

What I would need is the same condition that took into account my current selection in test...I tried

=if((Min({$} [Rev.Amount rev]))<0,0) but it's not working

Should I incorporate an =agg function as well?