Forum Discussion
Filtering Cumulative count by date
I'm working my way through the creation of a new report, with significant help from members of this group. I need to produce a Line and Column visual, showing, cumulatively, the number of project ...
below are snapshots of the data (with the Power BI field definitions) and then the measures I'm using. plus a resulting visual and shot of the data in the "Cumulative" measure entries, all showing 21.
In the earlier shot, showing the chart that was produced, it gives 21 as the result for all the measures, even if there is no data that obeys the filters, I tried adding the additional filter you suggested but it made no difference
v-lili6-msft Here's a shot of what I'd hope to achieve, admittedly the date scale is wrong as I'm looking for a monthly summary, but this was a quick'n'dirty in Excel