Funnel chart

[Anonymous]

Hi,

I have 2 questions for you:

1. Why gradient colors in the funnel chart? Is it possible to use only solid colors?

2. I have the funnel chart with fix sort

Match([qID_15876_Last step in cart],'Left in cart','Checkout','Personal info','Payment info','Reviewed, no confirm').

I'd like when I click on any segment, this segment keeps the same color and stay on the same place.

For example, if I click on the second segment from bottom, it keeps his color and stay on the same place, other segments will be colored grey color.

Please see my attached file.

Thank you,

[jerem1234]

1. I don't believe so, that's how the chart is designed.

2. Take a look at attached. You needed to ignore selections in your sort with {1}, so I added the function only(). For the colors, I used a pick(match()) instead of the if statements, but I did need one if to handle nulls when selection was made.

Sorting:

Match(only({1}[qID_15876_Last step in cart]),'Left in cart','Checkout','Personal info','Payment info','Reviewed, no confirm')

Colors:

if(Match([qID_15876_Last step in cart],'Left in cart','Checkout','Personal info','Payment info','Reviewed, no confirm'),

pick(Match([qID_15876_Last step in cart],'Left in cart','Checkout','Personal info','Payment info','Reviewed, no confirm'),

rgb(255,181,128), rgb(255,151,77), rgb(255,113,13), rgb(217,97,11),rgb(179,85,18)),

rgb(100,100,100))

Hope this helps!

[jerem1234 · Accepted solution]

Actually for colors, this formula is better:

if(isnull([qID_15876_Last step in cart]), rgb(100,100,100),

pick(Match([qID_15876_Last step in cart],'Left in cart','Checkout','Personal info','Payment info','Reviewed, no confirm'),

rgb(255,181,128), rgb(255,151,77), rgb(255,113,13), rgb(217,97,11),rgb(179,85,18)))

[Anonymous]

Thanks Jerem.