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.
Hello,
I am hoping I can get some help with a matrix. I have a transactions table where I want product on rows, income for a value, and for columns I want department and date.
Mr./Ms. Google search was not very fruitful.
Tom
Hi @talenzmeier ,
I will show you how to make this martix table in your case.
product | date | department | income |
P001 | 12/1/2021 | HR | 2 |
P001 | 12/1/2021 | IT | 3 |
P001 | 12/1/2021 | Warehouse | 4 |
P001 | 12/2/2021 | HR | 5 |
P001 | 12/2/2021 | IT | 6 |
P001 | 12/2/2021 | Warehouse | 7 |
P001 | 12/3/2021 | HR | 8 |
P001 | 12/3/2021 | IT | 9 |
P001 | 12/3/2021 | Warehouse | 10 |
P222 | 12/1/2021 | HR | 11 |
P222 | 12/1/2021 | IT | 12 |
P222 | 12/1/2021 | Warehouse | 13 |
P222 | 12/2/2021 | HR | 14 |
P222 | 12/2/2021 | IT | 15 |
P222 | 12/2/2021 | Warehouse | 16 |
P222 | 12/3/2021 | HR | 17 |
P222 | 12/3/2021 | IT | 18 |
P222 | 12/3/2021 | Warehouse | 19 |
P222 | 12/1/2021 | HR | 20 |
P333 | 12/1/2021 | IT | 21 |
P333 | 12/1/2021 | Warehouse | 22 |
P333 | 12/2/2021 | HR | 23 |
P333 | 12/2/2021 | IT | 24 |
P333 | 12/2/2021 | Warehouse | 25 |
P333 | 12/3/2021 | HR | 26 |
P333 | 12/3/2021 | IT | 27 |
P333 | 12/3/2021 | Warehouse | 28 |
This will expend the columns to two levels. Do some change on the style and will get the following matrix table.
pbix in the end you can refer.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@talenzmeier , what is the issues with that, post you drag department and date then you expand that using reverse Square Y icon, that should show both together
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 |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |