Forum Discussion
Line chart cumulative value not effect by date filter
Thanks for the reply,
I did try that but then the cumulative total seems to be caculating for the entire buisness and not just the individualy selected project. The line in yellow is the measure using ALL green line is the original measure using ALLSELECTED
It is from the Combined_All Table. I have managed to find a solution this morning.
I have used ALL instead of ALLSELECTED as originally suggested. Then i added an additional filter that then filteres by the selected project so im not seeing the totals for the entire company.
Hi Anonymous ,
The X-axis applied to the line chart is from which table field? Is it from the actual table COMBINED_ALL or a date dimension table? If it is from the date dimension table, please update the formula as below and check if you can get the result you want.
XBilling_Total_Parent_Currency running total in Period_Date =
CALCULATE (
SUM ( 'COMBINED_ALL'[Billing_Total_Parent_Currency] ),
FILTER (
ALLSELECTED ( 'COMBINED_ALL' ),
'COMBINED_ALL'[Period_Date] <= SELECTEDVALUE ( 'Datedimensiontable'[Date] )
)
)If the above still does not help you to get the right result, please provide some sample data and your visual settings just as below screenshot.
Best Regards
It is from the Combined_All Table. I have managed to find a solution this morning.
I have used ALL instead of ALLSELECTED as originally suggested. Then i added an additional filter that then filteres by the selected project so im not seeing the totals for the entire company.
Hi Anonymous ，
It's glad to hear that you have gotten the solution. And thanks for sharing the solution here. Could you please mark your post as Answered? It will help the others find the solution easily if they face the same problem with yours. Thank you.
Best Regards