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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
laxminarayana
Regular Visitor

Display the merged records in Report View

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.

Screenshot1.JPGScreenshot2.JPG

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


Thank you

Laxmi Narayana

1 ACCEPTED SOLUTION
10 REPLIES 10
amitchandak
Super User
Super User

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

Screenshot3.JPG

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

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.

 

Screenshot2.JPG

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.