Forum Discussion
Matrix table for order and payments
Hi,
May be you can try slightly different approach and see if it works instead of matrix.
You can try creating a composite summary table first.
create a summarized table where you calculate "Order Month", "Order Count", "Order Value", and "Average Value".
Then, bring your monthly payment data and pivot it, so that each month like Mar-25, Feb-25, etc., becomes a separate column.
Combine these two parts into one single table using Power Query or DAX (with functions like SUMMARIZE, ADDCOLUMNS, LOOKUPVALUE, etc.).
Finally, use a simple Table visual to display this new table directly in the report.
Thanks,
Bhavin
Super UserHi,
May be you can try slightly different approach and see if it works instead of matrix.
You can try creating a composite summary table first.
create a summarized table where you calculate "Order Month", "Order Count", "Order Value", and "Average Value".
Then, bring your monthly payment data and pivot it, so that each month like Mar-25, Feb-25, etc., becomes a separate column.
Combine these two parts into one single table using Power Query or DAX (with functions like SUMMARIZE, ADDCOLUMNS, LOOKUPVALUE, etc.).
Finally, use a simple Table visual to display this new table directly in the report.
Thanks,
Bhavin
Will try this solution. If its time consuming, then may be have it as 2 seperate visuals. Table for left visual and matrix for right visual and then try to make it look like same table using visualisation trickery.
