reference line on x-axis -line chart

[hadari]

Hi,

I want to add reference line on my x- axis.
my x-axis is my ItemID.
my Y axis is cumulative margin.

I tried to crate whale chart and I want to know where is the spot when my whale chart start  to descending with the reference line.

this is my line chart so far:

I tried to add the reference line with this expression:

Aggr(If(Rangesum(above(total ROUND(sum(margin)),0,RowNo())) = Max(total Rangesum(above(total ROUND(sum(margin)),0,RowNo()))), ItemID), ItemID)

but I don't see any line on my X-axis..

Can someone help me please? 

[Anil_Babu_Samineni]

IF you notice the reference line formed already, But the value maybe less than y-axis. So, please see the expression in KPI and look what value is getting? And the same time split the expression and see if values are coming.?

[hadari]

Hi! But I want a reference line on the x-axis so I suppose to see it.

How do I create vertical reference line?

[Anil_Babu_Samineni]

If you have sample QVF, please send us to see. In theory, With Vizlib extension this can be achieved.