Not showing record with blank fields

[JoseDavidM]

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

[v-jingzhang · Accepted solution]

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.

[DokDok]

Yes but it still cant show the count, it'll show blank rows with blank count

[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

[PhilipTreacy]

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

[DokDok]

a