Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

How to properly build a matrix in Power BI

  • 1.  How to properly build a matrix in Power BI

    Posted Sep 17, 2021 01:29 PM
    I am in the realization of my first matrix in Power BI, and I want to represent the amount of consumption per plan of each of the clients as follows:

    Currently in Power BI, I have been building the matrix as follows, where I place the column NombreCliente in its respective section and the Values ​​as each of the plans.

    enter image description here
    But if I do it this way as I am currently doing it in Power BI, it creates the matrix for me like this:

    enter image description here

    As you can see the plans of each of the clients, they are located below NombreCliente as if it were one more column.

    Is there a way to locate the name Original and Actual as if it were row or to represent my array as I add it in the image at the beginning of the question?

    I will make it clear that I already tried to move Original and Actual to the row section but it does not allow me since they are created from a measure.

    enter image description here
    enter image description here

    John Doe

  • 2.  RE: How to properly build a matrix in Power BI

    Top Contributor
    Posted Sep 17, 2021 01:47 PM
    Hi JD:

    Under format > VALUES  section choose "Show on Rows"

    It's just below here.

    I hope this helps.

    William Skelley
    Longmeadow MA