Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You can use conditional layouts. See attached.
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?