Columned chart not showing data from all the months.

[rabiafarooq]

Hi. So i am kinda new to power bi and i am working on the statistics of hospital's data. What i want is i want to visualize how many tests are against each patient per day.

For that i am using line and clustered columned chart.  Now the problem is the chart is showing the data for all the months of the year i.e march 2017-jan2018. But if i change the date and exclude the months of dec2017 and jan2018, it shows the correctly. .

[v-huizhn-msft]

Hi @rabiafarooq,

In your line and clustered columned chart, what field did you use in y-axis column? In your first screenshot, it shows all values from 2017/3/19 to 2017/12/7. In the second screenshot, why it only display Jan and December data, it is caused by the category values in [MRN], could you please share more details pr .pbix file for for further analysis? 

Best Regards,
Angelia