Duplicate field data Remove

[MSFTPBI]

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 within each ID. I'll apprecite your help.

[v-deddai1-msft · Accepted solution]

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

[amitchandak]

@MSFTPBI , Matrix visual. Stepped layout - Off

refer: https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual

https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/

[S_JB]

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_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