Forum Discussion

MSFTPBI's avatar
MSFTPBI
Frequent Visitor
5 years ago
Solved

Duplicate field data Remove

Hello,   I just started to work on Power BI. I have a table as shown below (RAW Data), but I want to present data in Tabel visual as shown in (Expected Result). Basically removing duplicate value w...
Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    Hi MSFTPBI ,

     

     You can use matrix to show what you want:

     

     

    You need to turn off stepped layout and icon in rows header:

     

     

    And turn off the  row subtotals :

     

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

     

    Best Regards,

    Dedmon Dai

       

S_JB's avatar
S_JB
Resolver III
5 years ago

You can go remove duplicate rows in Query editor.

 

In query editor, select the column that you want to remove duplicates for (in your example this would be Auto). Once this is highlighted, select remove rows in the home tab and then remove duplicates.

MSFTPBI's avatar
MSFTPBI
Frequent Visitor
5 years ago

S_JBThat would not work, becaus eit will remove the entire row. I need to remove only duplice field values. As shown in Expected Result image in my orignal post