Date slicer results not matching correct values

[DrPaul]

Hi all, new to Power BI so sorry if this has been asked already. I've got social media data in a Google Sheet connected as a web query to Power BI.  In Google Sheets, I can sum the range of new likes for Oct 1-21 and get a result of 2,850. However, when I visualise that column of data as a tile in Power BI and add a date slicer (set to the same time period) I get a result of 2,685. Anyone know what's causing the discrepancy?

[Anonymous]

Hi @DrPaul,

Can you please share a pbix file with some dummy data to test? It is hard to test with your scenario without any sample data.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[mahoneypat]

Your date range slicer is filtering your data to just October, but in your sheet pic I see one row from September at the bottom.  If you expand your slicer you will get same number.

Regards,

Pat