How to Handle Duplicate Rows in Table visual

[Anil2264]

Hi All,

I need a help to in power bi desktop, I have huge data and it has given as per heirarchy level but while i am trying to populate the data in table visual it shows as below. I only want to see uniq Finshied good & component combination in my table visual instead of duplicate as below of 123 & xyz.

Finished Good	Component
123	xyz
123	xyz
234	xtr
234	tyu
456	iuy

Thanks

[v-xiaotang]

Hi @Anil2264 

Actually, if you put them into Table visual, Table visual won't show duplicate rows.

Also, you can try this,

1. remove duplicates in Power Query Editor

2. create a new unique table by Dax code,

Test = DISTINCT('Table')

There is also something I have encountered before, if you add columns from other unrelated tables in the visual, it will also cause this situation.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[mh2587]

Use DISTINCT or VALUE Function