Forum Discussion
Creating a cumulative bar chart with additional categories
Hi,
PBI file attached.
Sorry for not clarifying.
So im talking about the same table but the dates of would not be of - like in my earlier example - 2022 but in 2025. Like this:
| Date | Total | MonthlyAmount | Subcategory | RuntimeMonths |
| Jan 25 | 40 | 4 | Dep 1 | 10 |
| Jan 25 | 36 | 3 | Dep 3 | 12 |
| Feb 25 | 55 | 5 | Dep 2 | 11 |
| Feb 25 | 40 | 4 | Dep 1 | 10 |
| Feb 25 | 36 | 3 | Dep 3 | 12 |
| Mar 25 | 55 | 5 | Dep 2 | 11 |
| Mar 25 | 40 | 4 | Dep 1 | 10 |
| Mar 25 | 36 | 3 | Dep 3 | 12 |
| Apr 25 | 40 | 4 | Dep 1 | 10 |
And the table is still supposed to look like the one you created but now were talking about 2025.
My solution should work irrespective of the year of the entries in the Date column.
Whenever i change the year of the dates to 2025 the cumulative T measure doesnt do anything. It stays empty.
I used your pbi file and only changed the dates and it doesnt work.I can help further only when i get access to the file. Share the download link and the problem very clearly.
I recreated what you did in this file but with the changed date.
Now the edited version doesnt show the data for the acumulated values.
You can see what i mean here:https://drive.google.com/file/d/1bHwAsEAM4Ry9AWiUIgcmSDF8iJdc8hNd/view?usp=drive_link
(Hope this link works)