Matrix table for order and payments

[MikeMe]

Is there any way of building this in PowerBI?

I am struggling to show the first 3 columns along with the rest of the data using Matrix table.

[Anonymous]

Hi @MikeMe 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[BhavinVyas3003 · Accepted solution]

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

[MikeMe]

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.