Forum Discussion
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 within each ID. I'll apprecite your help.
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
4 Replies
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 , 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/
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
