Table graph shows incorrect number of rows

[Zyg_D]

This is my simple data: 

This is the table graph (one row is missing):

How do I make the table graph show the missing row? I tried setting the filter to "is blank" or "is 0", but it did not help. 

[Anand24]

Hi @Zyg_D ,

I was able to re-create the same scenario as yours with one-to-many relationship and same columns taken into table viz.

Seems like your [Year] measure is at 'Don't Summarize'.

Change it to 'Sum' and your missing row should be visible.

Before(left) and After(right) image:

Don't forget to give thumbs up and Accept this as a solution if it helped you !!!

[westwrightj]

Hey @Zyg_D ,

   Thanks for reaching out to the community. I think I see what is going on in your question

    So I've used the same data you provided as my test data

Power BI will default to excluding blanks if you just place the different columns into a table and ask it to count

One solution is to make a measure like the following

Count of ID = 

COUNT(Table1[ID])

Which will provide the following result

There are other ways to go about what you are trying to accompish - but let us know if this works for you. If not we can noodle it around some more

[amitchandak · Accepted solution]

@Zyg_D , Create measure with +0

or try this option

[Greg_Deckler]

@Zyg_D I think there should be an option of showing blank values for your column. Otherwise, you can aways create a measure that always return 1 and add it to your visual (and then shrink it down to hide it)

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-show-items-no-data