Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Deleting Some Duplicate Data

Hello! I am very new to power BI so forgive me if this is simple question. 

 

I am trying to show who is on a particular project, while not displaying redundant information.

 

Data comes into power bi ( more or less)  like this :

 

Note: There is code to take an ID and match it to a name.

 

This issue is for the project "Notebooks" there are two BA's working on it, and when I create a table to display who is working on a specific project I get this :

 

When really want this to dispaly:

 

 

Any Ideas / suggestions would be much apprerciated!

 

Thanks

 

 

 

 

  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Anonymous  ,

    Here is what I suggest:


    > Create a new MATRIX visual 
    > Add all relevant columns (as below)

     

    > Hover your mouse on the visual and press on 

         button until greyed out.

    > Go to FORMAT tab > Row Headers > Turn off STEPPED LAYOUT


    > You should then get the below matrix

    Cheers
    Robin

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

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous  ,

    Here is what I suggest:


    > Create a new MATRIX visual 
    > Add all relevant columns (as below)

     

    > Hover your mouse on the visual and press on 

         button until greyed out.

    > Go to FORMAT tab > Row Headers > Turn off STEPPED LAYOUT


    > You should then get the below matrix

    Cheers
    Robin

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

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Anonymous 

      Thanks for the inital solution this worked until I had two columns with more than person in it. So instead of getting this:

      I would get this:

       

      Any ideas? Thanks