Forum Discussion

Paiman's avatar
Paiman
Frequent Visitor
5 years ago

Stacked Chart with 2 values

Hi Everyone,

 

I need help on how to create a stacked chart with 2 values? here's my sample of data, right now my stacked chart only show the stacked "hedge", I want the "Open" included

 

Hedge = will have varied stack

Open = will have 1 stack, because it only has data at the end of each risk_month

 

 

I've read several articles related with this, but mines a bit different, no? much appreciated for the help

 

commodityRecommOrNottrading_daterisk_monthCalc_Hedge3Calc_Open4
BTCRecommended11/30/20181/1/20201,041.80 
BTCRecommended12/28/20181/1/20201,833.60 
BTCRecommended1/25/20191/1/20204,028.70 
BTCRecommended2/22/20191/1/20207,359.10 
BTCRecommended3/29/20191/1/202016,126.50 
BTCRecommended4/26/20191/1/202021,114.60 
BTCRecommended5/31/20191/1/202053,049.00 
BTCRecommended6/28/20191/1/2020193,824.90 
BTCRecommended7/26/20191/1/2020217,778.60 
BTCRecommended8/30/20191/1/2020866,210.20 
BTCRecommended9/27/20191/1/20203,886,171.60 
BTCRecommended10/25/20191/1/20209,763,235.90236,764.10
Need Help
Show and Tell

1 Reply

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee
    5 years ago

    Do you need Open to be a separate stack?  If not, you can just use a measure like (replace Table with your actual table name).

     

    NewMeasure = SUMX(Table, Table[Calc_Hedge3] + Table[Calc_Open4])

     

    If so, you'll likely need to use the new Charticulator visual to make your desired chart.

    (9) Season 1 - Charticulator - YouTube

     

    Pat