Forum Discussion
Helper IICummulative vs individual in a line chart
I have to make a cumulative line chart where the user could see all reports user count summed up (cumulative? Or summarized?), I am not really sure this is doable. The cumulative needs to be able to be filtered so this type of graph:
Would have a 4 line which is the cumulative of all three projects' user count and it would be able to select in a slicer... is this even possible? Thanks in advance!
Hi AmazingRandom ,
According to your describe, here are my test data:
1.Create a measure
Running total = VAR X = CALCULATE( SUM('Table'[value1]), FILTER(ALL('Table'),'Table'[Date]<=MAX('Table'[Date]))) VAR Y = CALCULATE( SUM('Table'[value2]), FILTER(ALL('Table'),'Table'[Date]<=MAX('Table'[Date]))) VAR Z = CALCULATE( SUM('Table'[value3]), FILTER(ALL('Table'),'Table'[Date]<=MAX('Table'[Date]))) RETURN X+Y+Z2.Create a line chart
3.Create a slicer and use data column as value
4.Final output
I hope this can help you. If you still can't do it, please provide your documents and hide your personal information.
In order for you to solve the problem faster, you can refer to the following documentation
How to Get Your Question Answered Quickly - Microsoft Fabric Community
Best Regards,
Albert He
2 Replies
Hi AmazingRandom ,
According to your describe, here are my test data:
1.Create a measure
Running total = VAR X = CALCULATE( SUM('Table'[value1]), FILTER(ALL('Table'),'Table'[Date]<=MAX('Table'[Date]))) VAR Y = CALCULATE( SUM('Table'[value2]), FILTER(ALL('Table'),'Table'[Date]<=MAX('Table'[Date]))) VAR Z = CALCULATE( SUM('Table'[value3]), FILTER(ALL('Table'),'Table'[Date]<=MAX('Table'[Date]))) RETURN X+Y+Z2.Create a line chart
3.Create a slicer and use data column as value
4.Final output
I hope this can help you. If you still can't do it, please provide your documents and hide your personal information.
In order for you to solve the problem faster, you can refer to the following documentation
How to Get Your Question Answered Quickly - Microsoft Fabric Community
Best Regards,
Albert He
AmazingRandomQuick edit, I assume this could also be done as a running total instead?