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 2023
Check out the November 2023 Power BI update to learn about new features.
Fabric Community News unified experience
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Exclusive opportunity for Women!
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
The largest Power BI and Fabric virtual conference
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.
