Forum Discussion
Convert Matrix into a Table
Hi Team, Is it possible to convert a matrix into a table. I've used Matrix visual to pivot the data as per screenshot below. I'd like to use these columns in a separate table. If I can't conve...
All good, I've used Excel to get this sorted and then got Power Bi to pull that info from Excel
Hey Anonymous ,
can you please elaborate on you mean by you "loose" the pivoted values?
This is the nature of the table visual or in contrast the matrix visual.
But maybe activating "Show items with no data" resolves the issue you are facing:
Hopefully, this helps to tackle your challenge.
Regards,
Tom
I've got 2 tables.
Table 1 is standard table which I'm getting from Excel file, after which I've done some filtering on it.
Table 2 is also from a separate Excel file. I had to pivot it using Matrix visual to get the columns I needed.
I'd like to now call those pivoted columns into Table 1 and match it against each Agents.