Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
This is happening because rows are duplicates. You need to have an index column.
Please refer to these past discussions
In matrix or table view. If Qty is the sum, it should display one row.
Hi @ami
In Table view, could you please tell me why it is not displaying the two rows?
Thank you!!
Right-click on Qty in Visualization pane and use do not summarize option. Check for any other field there is no summarization.
Hi,
Thanks for the reply.
I have checked all the fields but, still not able to see the duplicate records
If possible please share a sample pbix file after removing sensitive information.
Thanks
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
This is happening because rows are duplicates. You need to have an index column.
Please refer to these past discussions
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.
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
Hi,
In Table view and I have tried with default summariztion setting but, not changed.