Forum Discussion
Creating a cumulative bar chart with additional categories
Hi,
PBI file attached.
Super UserHi,
Based on the data in the file, show the expected result in a Table format very clearly.
Sorry i messed up the data in the file i shared.
Here is a correct one:
https://drive.google.com/file/d/1bHwAsEAM4Ry9AWiUIgcmSDF8iJdc8hNd/view?usp=sharing
And this is what i need it to look like(with bars for each month instead of the three points of course):
So it always shows the accumulated monthly amount for each department and whenever there is an additional amount it just adds it to the amount of that department.
Also i might need it with a dynamic number of departments.
Thank you very much
- Ashish_Mathur
I do not see 3 dots there. Everything seems fine to me.
The image i sent is not the finished graph but only an edited version of what i want it to look like. Thats why i said the 3 dots in the image are only because i didnt want to create a bar for the months between april 2025 and january 2026. For practical reasons but they should of course be in the final visual.
- Ashish_Mathur
For Dep 3, information is available only for JFM 2026. There if i swap Year and Month on the X-axis, this is the image i get (with which i see nothing wrong)
Yes, but i need ALL of the monthly amount to be added up in every month after they are added.
In the ss you shared it resets after each year. I would like it to carry on the data from the previous years and departments.- Ashish_Mathur
Hi,
PBI file attached.
Yes, thank you very much thats what i have been looking for.
- Ashish_Mathur
You are welcome.