Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Gigi4691
Frequent Visitor

Table visual (Text) duplicate rows (1 table)

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!

Gigi4691_1-1718820807486.png

 

 

 

 

1 ACCEPTED 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. 

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

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

ryan_mayu
Super User
Super User

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. 





Did I answer your question? Mark my post as a solution!

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. 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.