The data cannot be summarized to the line chart

[JERRYJ]

Dear all,

My dashboard uses line chart to summarize monthly project counts. The data source is modified with fixed format and it could be also freshed to Power BI normally. However, the line chart did not show the counts of March, 2023 even the data is updated to the report. I did not know what is wrong? Any possibility could be reminded?

Regards

[JERRYJ]

You are correct! Date tables should include complete years. I found the problem and solved! Thanks very much!

[grantsamborn · Accepted solution]

Hi @JERRYJ 

Are you using a date table in your model?  Date tables should include complete years.

If this doesn't help,  can you show the following?

1)  Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...

2) Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

3) Please explain how you would expect to get from 1) to 2).

I hope this helps.