Forum Discussion
Table Visual not showing all rows
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
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.
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.
That's the grouping feature of matrix just like pivot table in Excel, duplicate values are grouped into 1 value.
3 Replies
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.
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.
That's the grouping feature of matrix just like pivot table in Excel, duplicate values are grouped into 1 value.