Data Matrix

[Anonymous]

Good day Community,

I am new to Power BI and am needing help. we provide micro finding to entrepreneurs. What I want to develop is a report that shows for any particular month how our income is comprised. for example, if we were repaid $10 000 in total for February 2022, how much of that was for February 2022 and how much of that was arrears recovered.

I have done this in Excel but the volumes of data is too much.

In the example below the total for a column will be the total payments for the month. The total for each row is when that payment was actually due.

I have imported all the data into power BI but an not sure how to create this.

Please help and thank you.

[v-luwang-msft]

Hi @Anonymous ，

What is your base table structure? Is it possible to provide your template data and what output to expect, remembering to remove confidential data.

And if you only want to create a Matrix，you could use the below visual.

Best Regards

Lucien