Power Bi Does not Show Duplicate Rows in the Table

[Pranali_R]

I have the data like this, I need to show all 

Order ID	Name	Surname	Date
1	Allen	Jacob	08-04-2021
2	Allen	Jacob	08-04-2021
3	Sarah	Taylor	10-04-2023
4	Jonah	Smith	11-04-2023
5	Will	Harbour	12-04-2023
6	Gregg	Owen	13-04-2023
7	Gregg	Owen	13-04-2023

I need to show all the records without the Order ID field. 

But in the Table Chart, The duplicate records are not shown. I have clicked on  "Dont Summarize" for all columns

Unless I add Order ID , I dont get all the rows projected in the table.

I only get 5 records

I want to show the highlighted records twice, even if they are duplicates

[mlsx4 · Accepted solution]

Hi @Pranali_R 

I don't think you will be able to show it unless you add the Order ID. It is a fundamental part of how PBI works. Even if you say not summarize, it won't show you a duplicate value unless you have some unique value to see everything.