Skip to Content

How to show two different lines for two KPI's in column chart of Webi report

Feb 09 at 03:09 PM


avatar image

Hi Experts,

Please help me on webi column chart to show two different measure lines on top of two KPI Bars.

I have attached an example screenshot for better understanding.

I want to show the lines like highlighted.


Guruprasad G

new-function.png (26.6 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Feb 09 at 03:28 PM

have you tried with combined column chart with 2 axis?target line you use in the second axis as two measure objects.

Show 4 Share
10 |10000 characters needed characters left characters exceeded

Thanks for this option Amit,

I have tried this before, but this option also showing the results as two lines up and down for the entire chart.

I need to display the line on each KPI's(ex: On Deskphone one horizontal line and on Jabber one horizontal line.

Let me know if we have any other options to achieve this.


Guruprasad G


create multiple variables for each KPI's and add those in the second axis.after that you will get one line for each KPI.


Hi Amit,

Created two separate variables for Deskphone and Jabber, still i am getting the same result.webi-chart.png

Deskphone=[S_Target >80] Where([A]="Desk Phone")

Jabber=[S_Target >80] Where([A]="Jabber")

In Value Axis 2 i have assigned these 2 variables.

webi-chart.png (29.5 kB)

might be it is happening due to the different scaling of both axis..if you know the range of second axis and set the min & ma scaling range instead of auto scaling.