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 MSCUST for a $150 discount!
We want your feedback!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
A Year in Review - December 2024
Find out what content was popular in the Fabric community during 2024.
