Matrix Help

[Anonymous]

Need to look like this all the way acrosswhat I have so far

Hi,

I want for my Power BI to look like excel all the way across as far as getting the data in the correct places. I only have that so far and I cant figure out how to get the rest of the data in order all cross by the group.

What I did so far to group them is create a new table and based off that table I made a matrix for both colums and put them in the "rows" section and made it drillthrough. How can I get the rest of the data across the matrix in order? Please help. THANKS!

table

[Anonymous]

HI @Anonymous ,

I'd like to suggest you to do unpivot column on your category fields to convert multiple value fields to attribute and value.

Unpivot columns (Power Query)
After these, drag category column to row, attribute on column , value on value fields.

Regards,

Xiaoxin Sheng

[Anonymous]

@Anonymous can you show me how this is done? I need to organize the colums exactly the same way to match certain rows. Thanks!

[Anonymous]

Hi @Anonymous ,

Can you please share some sample data and expect result for test?

Regards,

Xiaoxin Sheng