Forum Discussion
Cumulative bar line chart
Hi There,
Im having issues with the Cumulative Actual Installation counts (bar chart-Y axis) versus Cumulative Forecast Installation counts(line chart) in Power BI using Running Sum(Quick Measure)
In Power BI, for the month of Feb, the count is 10 but in a separate tabulated Excel sheet its 7. The difference is also for the following months ie 14 in Power BI and 10 in Excel sheet
You can see the difference in manual cumulative calculation for Cumulative Actual Installation when tabulated separately in Excel table
As per below Power BI Line Bar chart, can see that Im having issues with the Actual cumulative Installation counts (bar chart) versus Forecast Cumulative Installation counts (line chart).Forecast Cumulative Installation counts (line chart) is correctly plotted while Actual Cumulative Installation is not on monthly basis
Please assist on this using the below table
| Project Name | Location | Forecast Monthly Installation | Actual Monthly Installation |
| Java | US | 30-Jan-25 | 30-Jan-25 |
| Java | Japan | 30-Jan-25 | 30-Jan-25 |
| Java | China | 30-Jan-25 | 30-Jan-25 |
| Java | Indonesoa | 30-Jan-25 | 30-Jan-25 |
| Java | Malaysia | 30-Jan-25 | 30-Jan-25 |
| Java | Singapore | 28-Feb-25 | 28-Feb-25 |
| Volcano | Thailand | 28-Feb-25 | 28-Feb-25 |
| Volcano | Vietnam | 28-Feb-25 | 30-Mar-25 |
| Volcano | Canada | 28-Feb-25 | 30-Mar-25 |
| Volcano | France | 28-Feb-25 | 30-Mar-25 |
| Volcano | Italy | 30-Mar-25 | 28-Apr-25 |
| Volcano | Germany | 30-Mar-25 | 28-Apr-25 |
| BAU | Brazil | 30-Mar-25 | 28-Apr-25 |
| BAU | Kenya | 30-Mar-25 | 28-Apr-25 |
Manual Calculation in Excel
| Forecast Monthly Installation | Cumulative Forecast Installation | Actual Monthly Installation | Cumulative Actual Installation |
| Jan | 5 | 5 | 5 | 5 |
| Feb | 5 | 10 | 2 | 7 |
| March | 4 | 14 | 3 | 10 |
| April | 0 | 14 | 4 | 14 |
4 Replies
- audreygerred
Super User
I created a table with your data as well as a date dimension table. I then have an active relationship between the date in my dim table and actuals in your fact table. I created an inactive relationship from the date dim to forecast in your fact.
Then, I created a few measures:
RowCount = COUNTROWS('Table')RowCount running total in Date Actuals =CALCULATE([RowCount],FILTER(ALLSELECTED('DateDim'[Date]),ISONORAFTER('DateDim'[Date], MAX('DateDim'[Date]), DESC)))RowCount running total in Date Forecast =CALCULATE([RowCount],FILTER(ALLSELECTED('DateDim'[Date]),ISONORAFTER('DateDim'[Date], MAX('DateDim'[Date]), DESC)),USERELATIONSHIP('Table'[Forecast Monthly Installation], 'DateDim'[Date]))When I create the chart, I put month from my date dimension in the x-axis, (I am filtered to 2025 in the filter pane), and I have the two running total measures in: actuals is in columns and forecast is in line.Hi Audrey,
Could you please email me the .pbix file
Tried couple of times. Need to see where I'm getting it wrong
- audreygerred
Hi! Are you using a date table? If yes, what are your relationships?
Hi 5599jeeteh ,
Did audreygerred reply solve your problem? If so, please mark it as the correct solution, and point out if the problem persists.Best regards,
Adamk Kong
