Forum Discussion
Solved
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 ...
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
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