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

       

v-deddai1-msft's avatar
v-deddai1-msft
Community Support
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