Forum Discussion

JoseDavidM's avatar
JoseDavidM
Icon for Helper I rankHelper I
5 years ago
Solved

Not 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...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    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.

PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
5 years ago

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