Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Nathan99
Regular Visitor

Power bi report builder duplicates in table wizard

Hi, im trying to create a invoice PDF report using power bi report builder but the issue we're having is duplicate address in each order number. I've managed to get the order number to be distinct but if there is more then 1 item per order the address, customer name and postcode also duplicates. How do i stop this from happening?

Please see the screenshot below.

Nathan99_0-1709123267955.png

thanks,

1 REPLY 1
v-nuoc-msft
Community Support
Community Support

Hi @Nathan99

 

You seem to be running into a common problem when dealing with grouped data, when multiple items per order results in duplicate customer information.

 

You can try the following to resolve the issue:

 

Use the Row Grouping Feature: In the table wizard, utilize the row grouping feature to group your data by the order number.

 

Then, place the customer name, address, and postcode fields in the group header section rather than in the detail section.

 

This way, these fields will only be displayed once per order, regardless of the number of items.

 

Adjust the Visibility Settings: For the fields that are duplicating (address, customer name, postcode), adjust their visibility settings so they only appear once per group (order number) instead of with each item.

 

This can be done by setting these fields to only display in the group header or by using an expression to hide them after the first instance.

 

You can view the link below for more details:

 

Grouping pane in a Power BI paginated report - Power BI | Microsoft Learn

 

Hide an Item (Report Builder) - Microsoft Report Builder & Power BI Report Builder | Microsoft Learn

 

Regards, 

Nono Chen 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors