Calculations in a bar chart and plot a new line with bar chart values

[Karthi]

I have to create a chart as below, I have created the bard chart, the red and green bars. I need help creating the blue line, the LOB  calculations to be done and plot the blue line depends on the value of the LOB. 

Appreciate any help!!! thanks in advance.

[v-yulgu-msft]

Hi @Karthi,

That case, you can create a measure to calculate the values of LOB. Then, insert a "Line and clustered column chart" visualization to display data (columns and measure).

Regards,

Yuliana Gu

[Karthi]

Thank you for the reply. But how do we do that? we will have to look at row 1 Qty(or Demand) as my first LOB. for the 2nd LOB I will have to subtract Supply from row2 from Demand from row1 (Demand row1- Supply Row2)  or The  LOB from row1 - Supply from row2 .   We are not doing this calculation in single row, but will have to refer 2 rows for the calculation.  I am not sure how this can be coded? Could someone help me with this code? 

Thanks.

Karthi. 

[Karthi]

It is adding or subtracting QTY by row by looking at the demand/supply. If "S" subtract and if 'D' then add Qty and go on.....on...until end of rows. 

I need the code for this.