Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Not applicable


Hi Community


I've tried to create a PowerBi report. The Report is connected to a SharePoint-List. The List have a column "status", with two values "new" and "closed".

Now I've tried to create a Line Chart, who shows the List-items. Finally it should show, how many items are created per month, and how many are closed.




So, I can filter the elements with status "closed". That’s working. But the items with status "new" are not working as expected. The "problem" is that, it shows the total of the items with status "new". But what I want is a total of created items per month.


It should look like this:



So purple is a total of all created (new) items per month, and yellow are the closed ones per month.


I Think another thing is that when the status changed to closed, the reporting should show this item in the current month. (so I can't use the created field from sharepoint, maybe the modify column? or new one)

Do I need to create a measure for that?


Thanks for your help

Community Support
Community Support

Hi @Anonymous,


Here I made a sample like this.




In the sample I created two measures to achieve the goal.


Close = CALCULATE(COUNT(Table1[Status]),FILTER(Table1,Table1[Status]="closed"))
new = CALCULATE(COUNT(Table1[Status]),FILTER(Table1,Table1[Status]="new"))

Here is the result for your reference.




For more details, please check the pbix as attached. If it doesn’t meet your requirement, kindly share you sample data to me.




Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Not applicable

Hi Frank


Thanks for your solution. For me i think it is not the right one. Because with this measure it just count the actual status (new or closed).


- I should have one that counts the created items per month (that could be status new, or closed. For example: in Jan we create a item and close it after a week. So your measure doesnt count this to new...).


- The other line in the chart should show just the closed ones (i think for that is your measure good 😉 )


You can imagine it like a IT ticket system, you wanna know, how many tickets were opened last month....and how many closed...

I hope I could explain it better 😉

Helpful resources

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.


Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.


Fabric certifications survey

Certification feedback opportunity for the community.