Forum Discussion
NessFlood
Helper I
1 year agoCUMULATIVE SUM FOR MULTIPLE LINES
I am wanting a cumulative total for Actual, Budget and Forecast on the same line graph - the cumulative measure I'm using below works when I seelct my slicer but I think I need three separate measure...
- 1 year ago
thank you so much, that's perfect! 😃
lbendlin
Super User
1 year agoPlease provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
NessFlood
Helper I
1 year agoHi there, below is a similar graph to what I want to achieve and the data is below, thank you.
| Type | Date | Value |
| Actual | 1 July 2024 | $315,540.35 |
| Actual | 1 August 2024 | $457,343.22 |
| Actual | 1 September 2024 | $506,849.83 |
| Forecast | 1 July 2024 | $315,540.35 |
| Forecast | 1 August 2024 | $457,343.22 |
| Forecast | 1 September 2024 | $506,849.83 |
| Budget | 1 July 2024 | $453,725.8282 |
| Budget | 1 August 2024 | $453,725.8282 |
| Budget | 1 September 2024 | $453,725.8282 |