Hi All,

Very often we are expecting Alerters in Webi Charts like in Xcelsius  (Conditional Formatting) .

Yet we don’t have direct call , but it can be possible in Webi 4.0.

Workaround

* I want color coding in a column chart ,

   Green for Amount Greater than 5000000

   Red  for Amount less than 5000000

1. Create a variable for Amount Greater than 5000000

=[Amount] Where ([Amount]>5000000)

2.Create a variable for Amount Less than 5000000

Amount] Where ([Amount]<5000000)

3.Turn this table into Column Chart with Dual Value Axis , assign Greater than 5000000 to Axis 1 and Less than 5000000 to Axis 2

4.Right Click , Format Chart , Palette Style , Green for Primary Color and Red for Secondary color,

(Since we don’t have option to select our own colors(Red and Green) in webi like 3.X , we only have option to select the below palettes and change transparency)

Now you got your Chart with alerters , but only drawback is scales .

There could be a misperception that Greater than 5000000  and Less than 5000000 bars will at same height

to avoid this we got our own scale definition like in Xcelsius

5.Create two  variables

Max Amount

=Max([Amount])

Min Amount

=Min([Amount])

Select Value Axis

In Scaling , assign Minimum Value to “Fixed Value” and point Min Amount variable

assign Maximum Value to  “Fixed Value” and point Max Amount variable

Select Value Axis2

In Scaling , assign Minimum Value to “Fixed Value” and point Min Amount variable

assign Maximum Value to  “Fixed Value” and point Max Amount variable

Now , result will be

Hope you’ll get use of this