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 see uniq Finshied good & component combination in my table visual instead of duplicate as below of 123 & xyz.

 

Finished GoodComponent
123xyz
123xyz
234xtr
234tyu
456iuy

Thanks

Need Help
Tips and Tricks

2 Replies

  • 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.