Forum Discussion
Balance sheet graph stop at current month
Glad the measure is working!
Still it is not clear with the chart image, what is the output you need?
you are having all 12 months as Jan to Dec and not sure what output you are expecting and which is the cut off date's month.
Since the cut off date and values are correct, Can you try with only the "Stock on Hand2" measure and remove the other two and see?
Other testing you can do is:
Create table visual, with Month-YYYY, TGLBalsheet[balance], cut off date measure and the "Stock on Hand2" measure and see the output you want is working correctly. then change it to image. Later add other measures and see where you are hitting the issue.
Thanks
Hi sevenhills ,
Sorry for the late reply have been working on another piece of work.
below are a couple of screenshots of what I am expecting, and a snapshot of the data i am working with;
Data
Expected Graph (made up data). The orange line is already working correctly, it is the blue line (this year's data) that i need to stop at the end of the last completed month.
Currently the blue line continues at the maximum value for all months from Feb onwards