Forum Discussion

Anil2264's avatar
Anil2264
Helper I
4 years ago

How to Handle Duplicate Rows in Table visual

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...
Need Help
Tips and Tricks
v-xiaotang's avatar
v-xiaotang
Community Support
4 years ago

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.