Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I am a new user in Power BI Desktop, I have created a Table visual (data is only Text) with some columns filtered. (I have only 1 table).
As you can see, I am getting duplicate rows. Any idea how to remove the duplicate row?
Thank you!
Solved! Go to Solution.
I tried to remove a conditional column, a calculated column and changed date format, same problem, we can see the duplicate rows. If I extract the table visual in Excel file, remove duplicate in column 'Projets', the total of rows is ok.
Hi @Gigi4691 ,
May I ask if your problem has been solved. If the above reply was helpful, you may consider marking it as solution. If the problem is not yet solved, please feel free to ask us a question.
Best Regards,
Ada Wang
do you have any columns that apply the calculation on it? or check the date column if it is a date column or datetime column. if the time is hidden, it looks like the same data, but actually the value is different.
Proud to be a Super User!
I tried to remove a conditional column, a calculated column and changed date format, same problem, we can see the duplicate rows. If I extract the table visual in Excel file, remove duplicate in column 'Projets', the total of rows is ok.
User | Count |
---|---|
73 | |
70 | |
38 | |
24 | |
23 |
User | Count |
---|---|
96 | |
93 | |
50 | |
41 | |
40 |