Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a table as below
Emp ID |Managers |Roles
A | B | Unit head |
A | C | Biz HR |
A | D | Biz HR |
A | E | Biz HR |
A | F | Ops Controller |
A | G | Biz HR Manager |
A | H | Budget Approver |
Now when i try to pivot Roles column and values as Managers column, it gives me below output.
Emp ID|Unit head|Biz HR|Ops Controller|Biz HR Manager|Budget Approver
A | B | Error | F | G | H |
In Biz Hr column it given Error as there are three Biz Hrs for A ID.
Now how can i make table with mulitple rows as below output,
Emp ID |Unit Head |Biz HR |Ops Controller |Biz HR Manager |Budget Appover
A | B | C | F | G | H |
A | B | D | F | G | H |
A | B | E | F | G | H |
Any Help
Mohan V
Solved! Go to Solution.
@v-chuncz-msft thanks for the reply.
I didnt tried the power query,
But from here, https://community.powerbi.com/t5/Desktop/DAX-Pivot-table-with-multiple-values/m-p/580610#M274664
i got the solution what i need which answered by me only.
Thanks,
@Anonymous,
You may try to use Table.
@v-chuncz-msft thanks for the reply.
I didnt tried the power query,
But from here, https://community.powerbi.com/t5/Desktop/DAX-Pivot-table-with-multiple-values/m-p/580610#M274664
i got the solution what i need which answered by me only.
Thanks,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
82 | |
70 | |
63 |
User | Count |
---|---|
145 | |
111 | |
104 | |
84 | |
64 |