The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I have a dataset like this:
year | unit | user | skill | result |
2021 | A | Apple | X | 1 |
2021 | A | Apple | Y | 3 |
2021 | A | Brown | X | 2 |
2021 | A | Brown | Y | 3 |
2021 | B | Nick | X | 2 |
2021 | B | Nick | Y | 3 |
2021 | B | Joe | X | 3 |
2021 | B | Joe | Y | 3 |
2022 | A | Apple | X | 1 |
2022 | A | Apple | Y | 3 |
2022 | A | Matt | X | 1 |
2022 | A | Matt | Y | 2 |
2022 | A | Lucky | X | 1 |
2022 | A | Lucky | Y | 1 |
2022 | C | Phil | X | 2 |
2022 | C | Phil | Y | 3 |
2022 | C | Hally | X | 4 |
2022 | C | Hally | Y | 1 |
and I want to get a matrix like this:
2021 | 2021 | 2021 | 2021 | 2022 | 2022 | 2022 | 2022 | ||||
unit | count unit 2021 | count unit 2022 | skill | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 |
A | 2 | 3 | X | 1 | 1 | 3 | |||||
Y | 2 | 1 | 1 | 1 | |||||||
B | 2 | 0 | X | 1 | 1 | ||||||
Y | 2 | ||||||||||
C | 0 | 2 | X | 1 | 1 | ||||||
Y | 1 | 1 |
Which is the most efficient and smart way to do it?
Thanks,
Andrea
The most efficient way is to use two separate matrix visuals.