Forum Discussion
Creating a cumulative bar chart with additional categories
So i have basically done what is asked for in this post but as a bar chart: https://community.fabric.microsoft.com/t5/Desktop/Problems-with-formula-for-creating-cumulative-counts-for-a-Task/m-p/3374...
Hi,
PBI file attached.
Ashish_Mathur
Super User
Super UserMy 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.
- Ashish_Mathur
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)- Ashish_Mathur
Change the calendar table formula to
Calendar = CALENDAR(MIN(Data[Date]),MAX('Future Data'[Date]))Hope this helps.