Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
hi guys,
I've an excel file with grouped columns as below:
I need to import it in power bi as below:
any help will be much appreciated please.
Solved! Go to Solution.
Hi @Mai_Nashaat ,
Power BI will read the worksheet as is and will not matter whether rows or columns have been grouped. If you want to achieve a result similar to below, Power BI needs to be able to identify which rows are the main and subtotals. You can either do this via a conditional column or doing a merge with a table with data that indicates kind of total a row is.
After that, extra columns are created in PQ and total rows are removed.
Attached is a sample pbix to help you get started.
Proud to be a Super User!
Hi @Mai_Nashaat ,
Power BI will read the worksheet as is and will not matter whether rows or columns have been grouped. If you want to achieve a result similar to below, Power BI needs to be able to identify which rows are the main and subtotals. You can either do this via a conditional column or doing a merge with a table with data that indicates kind of total a row is.
After that, extra columns are created in PQ and total rows are removed.
Attached is a sample pbix to help you get started.
Proud to be a Super User!
Hi @Mai_Nashaat,
You can do this by selecting these fields and using Unpivot Selected Columns.
Did I answer your question? Mark this post as a solution if I did!
Consider taking a look at my blog: Forecast Period - Previous Forecasts
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
104 | |
93 | |
83 | |
64 |