Forum Discussion
Helper INot showing record with blank fields
Hi, i have a report that is not showing records when some columns are blank, the only way that i found to solve the issue was manually replace those values in excel by 0.
the fields that are causing the issue are the last 3 in the image above
help
Hi JoseDavidM
Did you try checking the option Show items with no data for fields in these visuals? In this way, it will show the records with blank values.
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
7 Replies
v-jingzhangCommunity Support
Hi JoseDavidM
Did you try checking the option Show items with no data for fields in these visuals? In this way, it will show the records with blank values.
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.Yes but it still cant show the count, it'll show blank rows with blank count
- PhilipTreacy
Super User
Hi JoseDavidM
Can you please provide your data and PBIX file, hard to figure this out without seeing the data and transforms in PQ.
When you say these rows are not showing - are they getting into the Data Model and not appearing in visuals? Or are they not even making it into the Data Model tables?
Check your Power Query steps - are they filtering out the rows in question? Are you filtering null or empty rows?
regards
Phil
- JoseDavidM
Hi Phillip
in this link you can find the PBIX and the XLS files https://drive.google.com/drive/folders/1eiE8yL78BDUodqjOk5r07UHLXPRqeOxE?usp=sharing
- PhilipTreacy
Hi JoseDavidM
I don't have access to that link, you'll need to change permissions for access from within Google Drive
Regards
Phil
- JoseDavidM
hopefully you will have access now
https://drive.google.com/drive/folders/1eiE8yL78BDUodqjOk5r07UHLXPRqeOxE?usp=sharing
