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