Table only showing unique values?

[Shamatix]

Hey Fellow users of Power Bi,

As the pictures shown below I have a table with a ton of values, however it only shows the unique values?

Forexample here it only shows 0 once, however I know the values 0 exsists 5 times as shown on picture number 2?

How can this be?

[JayHerrera]

You can click the dropdown arrow for this field and set to "Don't Summarize", this should display all values instead of "Sum". By default each value you add to a table is set to "Sum". 

[Shivagange]

After selecting "Don't summerize" option also it showing unique value.Don't know how data projection is working in power bi.

[san_jois]

Hi Shivagange,

Possibly you can try selecting 'Show items with no data' in the dropdown. This may help when the '0' being referred to in a row is not having any other cross references in the base table

[Greg_Deckler]

That's just how table visualizations work. If you need all of the instances, then you would need to add something to the table that would essentially make the rows unique.