Forum Discussion

Sam_Meyer's avatar
Sam_Meyer
Regular Visitor
2 years ago

Gaps in chart data when calculating cumulative total

I have a chart based on a running list of transfers for different funding cycles which can fall into 3 divisions. These transfers are adjustments to what we call our 'base' for the year and make up o...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
2 years ago

Hi,

Share data in a format that can be pasted in an MS Excel file.  Show the expected result in a Table format.

  • Sam_Meyer's avatar
    Sam_Meyer
    Regular Visitor
    2 years ago

    Data

    $ AmountDivisionImpact YearForecast CycleCycle #
    1150000562024Budget V11
    150000V12024Budget V11
    455000V12024Budget V11
    90000V12024Budget V11
    130000V12024Budget V11
    (107657)V12024Budget V11
    (284886)V12024Budget V11
    (115230)V12024Budget V11
    (263419)V12024Budget V11
    (165408)V12024Budget V11
    (527738)V12024Budget V11
    (44218)V12024Budget V11
    (840420)562024Budget V11
    (108675)562024Budget V11
    (449160)V22024Budget V11
    (150000)V12024Budget V11
    338524V12024Budget V11
    300000V12024Budget V11
    36378V12024Budget V11
    200000562024Budget V11
    200000562024Budget V11
    325000V12024Budget V11
    (342124)V12024Budget V11
    (298733)V12024Budget V11
    (358073)V12024Budget V11
    180000V12024Budget V32
    (505000)V22024Budget V32
    (36000)V22024Budget V32
    31000V12024Budget V32
    150000562024Budget V32
    (150000)V12024Budget V32
    840420562024Budget V32
    108675562024Budget V32
    175000V12024Budget V32
    500000V12024Budget V53
    500000V12024Budget V53
    24092V12024Budget V53
    112969V12024Budget V53
    44760V120242+105
    135580V220242+105
    65005620242+105
    137804V120242+105
    70390V120242+105
    40420V120242+105
    561045620242+105
    42000V120242+105
    600005620242+105
    (17064)V120242+105
    233865V120242+105
    160500V120242+105
    (14500)V120242+105
    50000V120242+105
    286755620242+105
    200000V120242+105
    148536V220242+105
    (490500)V120242+105
    230238V120242+105
    6003995620242+105
    (420000)V120242+105
    272000V120242+105
    125000V120242+105
    852000V120242+105
    104000V220242+105
    1000000V120242+105
    1335000V120242+105
    1841650V120242+105
    232000V120245+78
    281915V120245+78
    (150000)V120245+78
    1650000V120245+78
    57722623V12024Base0
    10340424V22024Base0
    21945822562024Base0
  • Sam_Meyer's avatar
    Sam_Meyer
    Regular Visitor
    2 years ago

    Desired Output - sorry for double reply I was exceeding character limit

    DivisionBaseBudget V1Budget V3Budget V52+105+7
    56219458222254672723645822236458222439750024397500
    V157722623568900405712604058263101.563956664.765970579.7
    V21034042498912649350264935026497383809738380

     

      • Sam_Meyer's avatar
        Sam_Meyer
        Regular Visitor
        2 years ago

        Hi Ashish, 

         

        Thank you for the reply and apologies for my delayed response - I had to wait for an updated version of Power BI to open your file. 

         

        I am running into one more issue - depending on the year, we can have cycles ranging from base all the way to 11+1 so my 'Forecast Cycle Order' table looks like this (we would like users to be able to select different years):

         

        If I include the 2023 data I have, which has 8+4 cycle data points as well, my calendar table looks like this: 

         

        Visualization below:

         

        How would I get the visualization to not include forecast cycles in the X-axis which do not have any activity in the selected year, given the x-axis is driven by the calendar table?

         

        For example: The 2024 data I provided only had data points related to Base, Budget V1, Budget V3, Budget V5, 2+10, and 5+7

         

        Thank you again