Forum Discussion
Gaps in chart data when calculating cumulative total
Super UserHi,
Share data in a format that can be pasted in an MS Excel file. Show the expected result in a Table format.
Desired Output - sorry for double reply I was exceeding character limit
| Division | Base | Budget V1 | Budget V3 | Budget V5 | 2+10 | 5+7 |
| 56 | 21945822 | 22546727 | 23645822 | 23645822 | 24397500 | 24397500 |
| V1 | 57722623 | 56890040 | 57126040 | 58263101.5 | 63956664.7 | 65970579.7 |
| V2 | 10340424 | 9891264 | 9350264 | 9350264 | 9738380 | 9738380 |
- Ashish_Mathur
PBI file attached.
Hope this helps.
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
- Ashish_Mathur
I cannot understand your question. Someone who does will help you.