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.
Hello everyone,
I have this excel spreadsheet updated weekly and uploaded in Power BI.
We realized that the latest rows are not showing in the visual (a simple table) but they are showing in the query.
This issue seems to be coming from the number columns (2 from the spreadsheet + 2 measure) because if you delete these 4 columns the table shows the correct data.
I tried to "Don't summarize" the columns but it doesn't work and I don't know what to change with my measures either (if I keep the measures only, the table doesn't show the latest update) ...
Thanks in advance for your help,
Nick
Solved! Go to Solution.
Please share your measures. If a measure returns blank, that row is filtered out from the table. It looks like you have no data currently meeting whatever criteria is in your measure(s).
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hi @mahoneypat,
You were right. I just replaced "null" by "0" in Power Query and the missing rows appeared on my visual,
Thanks a lot for your help!
Nick,
hi @Nick2358 ,
I agree with @mahoneypat here regarding your measure caluclations.
Also do check if there are any filters on your report or on your visual, which is filtering this data somehow and not showing it.
Thanks,
Pragati
Please share your measures. If a measure returns blank, that row is filtered out from the table. It looks like you have no data currently meeting whatever criteria is in your measure(s).
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hi @mahoneypat,
You were right. I just replaced "null" by "0" in Power Query and the missing rows appeared on my visual,
Thanks a lot for your help!
Nick,
Hi @mahoneypat,
My measures are the following:
"DPM" and "In Month Actual" being my 2 number columns. And yes the both contain blanks and return blanks in some rows. However I didn't apply any filter to remove blanks ...
Thanks a lot for your help,
Nick,
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |