Translate loan overview from Excel to PowerBi

Hi tormi ,

According to your description, I made a simple sample and here is my solution.

You can transpose columns like the screenshot below.

About how to tranpose your table, please refer to the following document.

Transpose (rotate) data from rows to columns or vice versa (microsoft.com)

And then you can use Power BI Desktop to connect the excel.

If the table is right, click "load", and if the name of column is wrong, please click "transform data" to use "use first row as headers" in Power Query.

Then you can put your columns into a table in orders.

And you can put your columns into a line and clustered column chart in orders.

Please follow these documents.

Connect to Excel in Power BI Desktop - Power BI | Microsoft Learn

The Power Query user interface - Power Query | Microsoft Learn

Table visualizations in Power BI reports and dashboards - Power BI | Microsoft Learn

Visualization types in Power BI - Power BI | Microsoft Learn

I attach my sample below for your reference.

Best Regards,
Community Support Team _ xiaosun

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.