Forum Discussion

JayBI's avatar
JayBI
Regular Visitor
5 years ago
Solved

Create matrix row header

Hello,   I am an absolute beginner in Power BI and only have a week of experience.   I have two data tables which have a relationship with a common date table, and I've created a matrix that show...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi JayBI 

    You need to build a hierachy in martix row. Try Append function to build a new table and transform the table by Unpivote in Power Query Editor .

    Append:

    Select Revenue and Cost columns and use Unpivote in Transform.

    Then build a matrix as below. Don't forget to turn off stepped layout function in Format.

    Best Regards,

    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi JayBI 

You need to build a hierachy in martix row. Try Append function to build a new table and transform the table by Unpivote in Power Query Editor .

Append:

Select Revenue and Cost columns and use Unpivote in Transform.

Then build a matrix as below. Don't forget to turn off stepped layout function in Format.

Best Regards,

Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.