Hello PBI Experts,
We need some help in achieving below output table in power bi matrix visualization. We have also mentioned the input table below. Request you all experts, if you have any workaround then please feel free to reply on this mail or connect with me to help us on this requirement.
Note: We have tried matrix visualization in power bi and we have noticed that when we add the first column in rows it group by 1st category and then when we add second column by default it does group by on 2nd category however the requirement here is to not to group by on 2nd category and show all the rows associated to that categories. If we turned off the stepped layout on row headers, then the second category comes in columns but that's not meeting the requirement.
Output:
| Meeting Invitee & Subject | Meeting-Start Time | Meeting-EndTime | Meeting Category |
| Abc@test.com | |||
| testsub1 | 1/1/2020 7:30 | 1/1/2020 8:00 | Cat1 |
| testsub2 | 1/12/2022 13:00 | 1/12/2022 13:30 | Cat2 |
| testsub3 | 8/8/2022 2:00 | 8/8/2022 2:30 | Cat3 |
| testsub4 | 8/8/2022 3:00 | 8/8/2022 3:30 | Cat1 |
| testsub5 | 8/9/2022 3:00 | 8/9/2022 3:30 | Cat2 |
| DEF@test.com | |||
| testsub10 | 8/14/2022 2:00 | 8/14/2022 2:30 | Cat1 |
| testsub6 | 8/10/2022 3:00 | 8/10/2022 3:30 | Cat3 |
| testsub7 | 8/11/2022 2:00 | 8/11/2022 2:30 | Cat1 |
| testsub8 | 8/11/2022 3:00 | 8/11/2022 3:30 | Cat2 |
| testsub9 | 8/13/2022 2:00 | 8/13/2022 2:30 | Cat3 |
| GHI@Test.com | |||
| testsub11 | 8/15/2022 2:00 | 8/15/2022 2:30 | Cat2 |
| testsub12 | 8/16/2022 2:00 | 8/16/2022 2:30 | Cat3 |
| testsub13 | 8/17/2022 2:00 | 8/17/2022 2:30 | Cat1 |
| testsub14 | 8/17/2022 3:00 | 8/17/2022 3:30 | Cat2 |
| testsub15 | 8/18/2022 2:00 | 8/18/2022 2:30 | Cat3 |
| testsub16 | 8/19/2022 2:00 | 8/19/2022 2:30 | Cat1 |
| testsub17 | 8/19/2022 3:00 | 8/19/2022 3:30 | Cat2 |
| GHI2@Test.com | |||
| testsub16 | 8/19/2022 3:00 | 8/19/2022 3:30 | Cat2 |
| testsub16 | 8/19/2022 2:00 | 8/19/2022 2:30 | Cat1 |
Input table:
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.
Fabric Community Update - March 2025
Find out what's new and trending in the Fabric community.
