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
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
