Forum Discussion

Pranali_R's avatar
Pranali_R
Frequent Visitor
3 years ago
Solved

Power Bi Does not Show Duplicate Rows in the Table

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

Order IDName SurnameDate
1AllenJacob08-04-2021
2Allen Jacob08-04-2021
3Sarah Taylor10-04-2023
4JonahSmith11-04-2023
5WillHarbour12-04-2023
6GreggOwen13-04-2023
7GreggOwen13-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's avatar
    mlsx4
    3 years ago

    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.

1 Reply

  • mlsx4's avatar
    mlsx4
    Memorable Member
    3 years ago

    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.