Forum Discussion

LenaRamirez's avatar
LenaRamirez
Regular Visitor
2 years ago
Solved

Display Total of Measure on Line Chart

I am new to Power BI.    I have the below visual Table. I would like to hace a Line Chart display the total under "Available To Stock Match" which is a simple measure - Stock Match Qty = [Total Ove...
Need Help
  • suparnababu8's avatar
    suparnababu8
    2 years ago

    Hi LenaRamirez 

    You have to correct your meausre to avoid negative values. First you create a calculated as mentioned below to avoide negative values.

    Stock Match Qty = 
 VAR StockMQty = [Total Overall Inventory]-[Total Stock Match]-[Total STO]
RETURN IF(StockMQty < 0,0,StockMQty)

    Then you create a measure based on this calculated column and use that measure in your line chart. 
    I hope it'll work.

    Thanks!

     

suparnababu8's avatar
suparnababu8
Icon for Super User rankSuper User
2 years ago

Hi LenaRamirez 

You have to correct your meausre to avoid negative values. First you create a calculated as mentioned below to avoide negative values.

Stock Match Qty = 
 VAR StockMQty = [Total Overall Inventory]-[Total Stock Match]-[Total STO]
RETURN IF(StockMQty < 0,0,StockMQty)

Then you create a measure based on this calculated column and use that measure in your line chart. 
I hope it'll work.

Thanks!