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 Overall Inventory]-[Total Stock Match]-[Total STO]

The issue that I am finding is that since there are negative numbers and I currently have those filtered on the table visual, the line chart is trying to calculate the negative values. I only need positive values. Basically, I need the total on "Available to stock match" to also show on the line chart.

 

 

 

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!

     

2 Replies

  • 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!