Forum Discussion
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
- Anonymous7 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 matrixCheers
Robin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- AnonymousNot 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 matrixCheers
Robin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.- AnonymousNot 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