Forum Discussion
Disable drop duplicates from table visual
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?
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
2 Replies
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
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
