Date slicer results not matching correct values

DrPaul · ‎10-20-2020

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 · ‎10-22-2020

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 · ‎10-20-2020

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

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube