Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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.
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.
That's the grouping feature of matrix just like pivot table in Excel, duplicate values are grouped into 1 value.
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.
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.