Disable drop duplicates from table visual

[markmess77]

I have a table visual in my report, but am experiencing an issue with "duplicate" rows. An example of my desired output of the visual would be

Company Name	Country	Category
123 Company	USA	1
123 Company	USA	1
123 Company	USA	2
123 Company	USA	3

However, the table visual automatically drops the duplicate rows so my actual output is

Company Name	Country	Category
123 Company	USA	1
123 Company	USA	2
123 Company	USA	3

However, these rows are not true duplicates and should not be dropped. There is another column that differentiates the two, but cannot be displayed on the report. For example, behind the scenes the table looks like

Company Name	Country	Category	Confidential column (cannot be displayed)
123 Company	USA	1	1
123 Company	USA	1	2
123 Company	USA	2	3
123 Company	USA	3	4

This issue would easily be resolved if I could simply disable the visual from automatically dropping duplicates. However, I cannot seem to find the ability to do so. Am I missing something simple?

[v-yiruan-msft · Accepted solution]

Hi @markmess77 ,

Base on my research, Power BI will remove the duplicate rows automatically when put fields in visual. Sorry that I didn't find other good solution to prevent dropping duplicate rows except adding another column with unique values(just like @amitchandak suggested). You can also refer the solution in the following threads and check whether they can help you achieve your requirement.

Displaying rows with a duplicate same-column value

Duplicate data in Table visualization - Displaying as is Data

Best Regards

[amitchandak]

@markmess77 , power bi display distinct set when all columns are un summarized.

Add an index column in power query and add that to the table - https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi