Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hy,
my name is Wübbo and I use the first time PowerBi. In the past I get some skills to Work with Excel, but I see, that PowerBi ist different.
Ok, why I am hear:
I want to Create a Matrix with four Columns like in this Example:
Overview of the Projects for each Employee
Name | Manager | Support 1 | Support 2 |
Michael | 2 | 3 | 2 |
Tom | 6 | 2 | 0 |
Linda | 3 | 0 | 1 |
My database are two Tables:
1. Project Overview
Project | Manager | Support 1 | Support 2 |
A2586 | 3 | 1 | 2 |
A2587 | 1 | 2 | 1 |
A2588 | 2 | 3 | 3 |
A2589 | 2 | 2 | 3 |
A2590 | 2 | 2 | 3 |
A2591 | 2 | 1 | 2 |
A2592 | 1 | 1 | 3 |
A2593 | 1 | 3 | 2 |
A2594 | 2 | 3 | 2 |
A2595 | 3 | 1 | 2 |
A2596 | 2 | 3 | 1 |
2. Employ Overview
ID | Name |
1 | Michael |
2 | Tom |
3 | Linda |
I have no Idea how i can great this visual withe PowerBi and I try it for 5 Days, so I would be glad I someone please give my an hint 😉
Thanks
Wübbo
Solved! Go to Solution.
@Wuebbo , option one is to unpivot first table and join withs Second
https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose: https://yodalearning.com/tutorials/power-query-helps-transposing-data/
Option 2 is to join table 1 to table 2, three times, one active and 2 inactive join. create three measure and use userelation in 2 measures
Thanks a lot,
It works i am so glad.
I use the Dax "USERELATIONSHIP" to count the specific members.
Again, thanks to evereyody for the help.
Hi @Wuebbo ,
I'm a little confused about your sample data. Can you please share the computing logic with us? Is the Employ ID same as 1,2,3 in Projects? How do we count the Manager, Support 1 and Support 2 for each Employee?
Hi @Wuebbo ,
You could upload a sample into OneDrive for Business. And then share the link with us. Thanks!
Note: Please share a sample rather your actual file. If there is any sensitive data, please replace them with others.
@Wuebbo , option one is to unpivot first table and join withs Second
https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose: https://yodalearning.com/tutorials/power-query-helps-transposing-data/
Option 2 is to join table 1 to table 2, three times, one active and 2 inactive join. create three measure and use userelation in 2 measures
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |