The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi all.
I am rather new to PowerBi, so I don't have a full grasp on everything yet 🙂
However I have made a setup to visualize a loan month-to-month in Excel, however, I would like to have something similar in PowerBi. So how can this be achieved?
1. How do I need to structure the data in Excel to be able to do this in PowerBi?
2. How do I visualize this in PowerBi after? (I probably will find out if part 1 is correct).
The red-colored rows from the left are loans, and the green-colored rows are cash capital, so these should somehow be calculated against each other. I want the option to visualize each loan separately + show a total and calculate the total against the capital accounts.
In the end I would add previous years into this mix.
Thanks for any help.
Solved! Go to Solution.
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.
Wow, what a fantastic answer. This is hands down the best answer I have ever recieved in a forum.... and on my first ever post here!! Thanks for beeing a fantastic person!
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
93 | |
81 | |
63 | |
56 |
User | Count |
---|---|
247 | |
122 | |
110 | |
77 | |
72 |