Forum Discussion
Gaps in chart data when calculating cumulative total
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_Mathur2 years ago
Super User
I cannot understand your question. Someone who does will help you.