Table format not showing correct figures

[Gaurav_84]

Hi All,

Table data in one of my Powerbi report is not coming correctly. below is sample data based on severity it showing 6 line items with sevirity 1 & 2 although my graps shows 6 items in total but my report shows only 2.

Regards

[amitchandak · Accepted solution]

@Gaurav_84 , when all records are same, power bi shows grouped/ distinct data.

You can add measure in table, in the visual

countrows(Table) 

Add some distinct field to get 6 rows. or you can an index column in power query and use that in visual

https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi