Multiple Rows and Columns

[arosenberg]

Hi All,

I am attempting to create a table in Power BI thats a bit different from ones that I've seen so far. The table should look like the below where there are multiple columns and rows. Employee ID, Position, and Name are all for the same person. 

		Employee ID	12345	67890	24680	13579
		Position	Manager	Specialist	Analyst	CEO
Client Name	Product Name	Name	Person 1	Person 2	Person 3	Person 4
Client A	Product A
Client B	Product B
Client C	Product C
Client D	Product D

Anyone have any idea how I can make something like this in Power BI. Thanks in advance for your help.

[vicky_ · Accepted solution]

You can use the Matrix Visual, and just put the client / product names in rows, and the employee id, position and name in the columns. Once set up, drill down on both the columns and rows to get the matrix. 
See https://learn.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual for more info.