Display the merged records in Report View

[laxminarayana]

Hi,

I have a two rows of data which are same except quantity. In power bi The records are not merged in DataView but merged in Report View.

Is there any way to display the mergd records in Data view?

Thank you

Laxmi Narayana

[amitchandak]

In matrix or table view. If Qty is the sum, it should display one row.

[laxminarayana]

Hi @ami

In Table view, could you please tell me why it is not displaying the two rows?

Thank you!!

[amitchandak]

Right-click on Qty in Visualization pane and use do not summarize option. Check for any other field there is no summarization.

[laxminarayana]

Hi,

Thanks for the reply.

I have checked all the fields but, still not able to see the duplicate records

[amitchandak]

If possible please share a sample pbix file after removing sensitive information.
Thanks

[laxminarayana]

Hi @amitchandak 

Thank you for the reply.

Please find the attached pbix file link to download. Hope this will help you in understanding the issue.

https://slack-files.com/T2DKMMEJ1-FR93WLKST-ad5b1743c4

Regards

Laxmi Narayana

[amitchandak · Accepted solution]

This is happening because rows are duplicates. You need to have an index column.

Please refer to these past discussions

https://community.powerbi.com/t5/Desktop/Two-rows-show-in-the-src-db-Advanced-Editor-Desktop-tbl-but...

https://community.powerbi.com/t5/Desktop/Duplicate-data-in-Table-visualization-Displaying-as-is-Data...

[laxminarayana]

Thanks for the reply.

Yes, I have a data records with some duplicate records of same sales order, item, batch and etc.. so, in those cases we dont have an option to see the records.

Either the records are unique or add an index columns for the records.

[Icey]

Hi @laxminarayana ,

Is this problem solved?

If it is solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If not, please let me know.

Best Regards
Icey

[laxminarayana]

Hi,

In Table view and I have tried with default summariztion setting but, not changed.