Forum Discussion
Paginated Report - Stop Grouping
Hi,
This sounds like a really simple question but for the life of me I cant seem to find how to do it.
In powerbi paginated report builder I am connecting to a datamart with data that has duplicate rows intentionally.
| ID | Date | Mark |
| 1 | 02/02/2024 | Y |
| 1 | 02/02/2024 | Y |
The marks are for morning and afternoon, when I add them to a paginated report as a table it groups them, when I delete the group only it only shows 1 row.
Is there a setting to not supress duplicates ?
Many thanks
Chris
Hi CEllis ,
Uncheck this box to see two records without deleting the group:
Result:
Best Regards,
ZhuIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
Hi CEllis
This is because by default, when using paginated reports, it automatically groups the data. Here is a link where it will show you how to remove the grouping to show all the rows as expected. How to remove Grouping after report is built? – SQLServerCentral Forums
Hi GilbertQ
The properties doesnt show the tab grouping from the post steps.
'I assume that the report is using a Table, if so, click on the table to select it, then right click and select properties. In the properties window select the groups tab and in here you can remove all the groups just by highlighting and removing.'
Many thanks
Chris
Thanks for the reply form GilbertQ.
Hi CEllis ,
This feature is here:
By th way, you can uncheck this option when creating the table and it will expand the group:
Best Regards,
Zhu
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
