Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello everyone,
I hope you can help me with this matrix. I have the following table that I want to display in a matrix. The table is sorted (just as I would like it to appear in Power BI). This table consists of the approval process for 3 documents (IC-GP-FR-010, IC-GP-FR-011, IC-GP-IN-009). The approvers are assigned in order (Column "Responsable"). Each approver has a start date (Column "Inicio Real") which is when their turn to approve the document begins, and an end date (Column "Fin Real") which is when they finish approving. Once an approver completes their approval, the next approver in the row can proceed to approve.
Flujo de Revisión | Documento | Responsable | Inicio Real | Fin Real |
11000-FT-00156 | IC-GP-FR-010 | LUIS | 10/03/2022 | 11/03/2022 |
11000-FT-00156 | IC-GP-FR-010 | JUAN JOSÉ | 11/03/2022 | 6/04/2022 |
11000-FT-00156 | IC-GP-FR-010 | NATALY | 6/04/2022 | 7/04/2022 |
11000-FT-00156 | IC-GP-FR-010 | LUIS | 7/04/2022 | 11/04/2022 |
11000-FT-00156 | IC-GP-FR-010 | MANUEL | 11/04/2022 | 19/04/2022 |
11000-FT-00156 | IC-GP-FR-010 | JAIME | 19/04/2022 | 24/05/2022 |
11000-FT-00156 | IC-GP-FR-010 | MAURICIO | 24/05/2022 | 9/06/2022 |
11000-FT-00156 | IC-GP-FR-010 | CAROLINA | 9/06/2022 | 5/07/2022 |
11000-FT-00156 | IC-GP-FR-010 | SUSAN | 5/07/2022 | 1/09/2022 |
11000-FT-00156 | IC-GP-FR-010 | MARITA | 1/09/2022 | 30/09/2022 |
11000-FT-00156 | IC-GP-FR-010 | JORGE | 30/09/2022 | 6/10/2022 |
11000-FT-00156 | IC-GP-FR-010 | JOSÉ | 6/10/2022 | |
11000-FT-00156 | IC-GP-FR-011 | LUIS | 10/03/2022 | 11/03/2022 |
11000-FT-00156 | IC-GP-FR-011 | JUAN JOSÉ | 11/03/2022 | 6/04/2022 |
11000-FT-00156 | IC-GP-FR-011 | NATALY | 6/04/2022 | 7/04/2022 |
11000-FT-00156 | IC-GP-FR-011 | LUIS | 7/04/2022 | 11/04/2022 |
11000-FT-00156 | IC-GP-FR-011 | MANUEL | 11/04/2022 | 19/04/2022 |
11000-FT-00156 | IC-GP-FR-011 | JAIME | 19/04/2022 | 24/05/2022 |
11000-FT-00156 | IC-GP-FR-011 | MAURICIO | 24/05/2022 | 9/06/2022 |
11000-FT-00156 | IC-GP-FR-011 | CAROLINA | 9/06/2022 | 5/07/2022 |
11000-FT-00156 | IC-GP-FR-011 | SUSAN | 5/07/2022 | 1/09/2022 |
11000-FT-00156 | IC-GP-FR-011 | MARITA | 1/09/2022 | 2/09/2022 |
11000-FT-00156 | IC-GP-FR-011 | JORGE | 2/09/2022 | 7/09/2022 |
11000-FT-00156 | IC-GP-FR-011 | JOSÉ | 7/09/2022 | |
11000-FT-00156 | IC-GP-IN-009 | LUIS | 10/03/2022 | 11/03/2022 |
11000-FT-00156 | IC-GP-IN-009 | JUAN JOSÉ | 11/03/2022 | 6/04/2022 |
11000-FT-00156 | IC-GP-IN-009 | NATALY | 6/04/2022 | 7/04/2022 |
11000-FT-00156 | IC-GP-IN-009 | LUIS | 7/04/2022 | 11/04/2022 |
11000-FT-00156 | IC-GP-IN-009 | MANUEL | 11/04/2022 | 19/04/2022 |
11000-FT-00156 | IC-GP-IN-009 | JAIME | 19/04/2022 | 24/05/2022 |
11000-FT-00156 | IC-GP-IN-009 | MAURICIO | 24/05/2022 | 23/06/2022 |
11000-FT-00156 | IC-GP-IN-009 | CAROLINA | 23/06/2022 | 5/07/2022 |
11000-FT-00156 | IC-GP-IN-009 | SUSAN | 5/07/2022 | 11/07/2022 |
11000-FT-00156 | IC-GP-IN-009 | MARITA | 11/07/2022 | 30/09/2022 |
11000-FT-00156 | IC-GP-IN-009 | JORGE | 30/09/2022 | 4/10/2022 |
11000-FT-00156 | IC-GP-IN-009 | JOSÉ | 4/10/2022 | 3/07/2023 |
However, in Power BI, when I try to create the matrix, it appears disordered. I have tried to sort it by adding an index column. However, it only appears with options for showing it as a sum, average, and not without summarizing. Therefore, I cannot sort it using the index.
I hope you can help me. I appreciate it in advance.
Hello @rz21c97 ,
after you added an index column , on your table click the column you wish to sort and seelct sort by coolum nand choose by index column
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
21 | |
15 | |
15 | |
11 | |
7 |
User | Count |
---|---|
25 | |
24 | |
12 | |
12 | |
11 |