Forum Discussion
Multiple Queries to Make Dynamic Report
Hi kjcompton ，
According to your statement, I think you only add columns into matrix column field and value field. I think you need to expand your matrix by adding columns in matrix row field.
I think your data table should look like an unpivot table. I suggest you to add an index before your unpivot or add an index by group after unpivot.
For refernece：
Create Row Number for Each Group in Power BI using Power Query
Your table should look like as below.
Matrix is as below.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi kjcompton ，
According to your statement, I think you only add columns into matrix column field and value field. I think you need to expand your matrix by adding columns in matrix row field.
I think your data table should look like an unpivot table. I suggest you to add an index before your unpivot or add an index by group after unpivot.
For refernece：
Create Row Number for Each Group in Power BI using Power Query
Your table should look like as below.
Matrix is as below.
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.