Table Visual not showing all rows

[StuartSmith]

I have a dataset that has a column that contains no-unique values (project codes) and in the data view it shows the multiple rows.

But if I add a table visual to the report it only show the ID value once...

I have changed the value setting to "Dont Summarise", I even tried changing the column type to "Text", but still the table visual doesnt  so a true representation of the data set.  Any ideas why? Thanks

[camargos88 · Accepted solution]

Hi @StuartSmith ,

Try adding a column that has a different value to it, so it will replicate the values, by default it doens't show the repeated rows.

[V-pazhen-msft · Accepted solution]

@StuartSmith 

The repeated value is hidden by default. Try add other columns to the table visual to differentiate the same value of that specific column, usually they can be dates, products, type,etc.

To be clear: 

 

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
  

[AntrikshSharma · Accepted solution]

That's the grouping feature of matrix just like pivot table in Excel, duplicate values are grouped into 1 value.

[V-pazhen-msft · Accepted solution]

@StuartSmith 

The repeated value is hidden by default. Try add other columns to the table visual to differentiate the same value of that specific column, usually they can be dates, products, type,etc.

To be clear: 

 

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
  

[camargos88 · Accepted solution]

Hi @StuartSmith ,

Try adding a column that has a different value to it, so it will replicate the values, by default it doens't show the repeated rows.