Color coding of the funnel visual with positive and negative values

[kkmec]

Hey everybody,

Can the funnel visual show both the positive and negative values? I would like to show positive values in blue and negative values in red color.

- here the negative values should be shown with a red bar.

Thank you for any suggestions.

Cheers,

[Zubair_Muhammad]

@kkmec

Yes you can do it using Color Saturation Property of the Charta and a MEASURE.

Please see the attached file.

STEPS:

1)First create a MEASURE to assign a 0 value to negative values and 1 to positive values.

This will be used in Color Saturation Property
2)Next add a MEASURE or a COLUMN to convert negative values to positive using ABS function
3) Select Colors from DataColors

[Zubair_Muhammad · Accepted solution]

@kkmec

File attached here