Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
82 | |
67 | |
61 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |