Forum Discussion
Resolver IITranspose & Pivot using Power Query
Hi arimoldi
Excel
I retested your problem by first importing the excel table into the power bi desktop and going to the power query interface to get the following table:
1. If you don't want empty values to display data, consider replacing "null" with Spaces.
In the same step, you just need to change the "0" to " ".
Use the first line as the title.
Delete "Changed Type1" from the step bar on the right.
2. Select the first column and click Fill -> Down. The first column will be filled in automatically.
Finally, the column with the date header is also selected for unpivot.
Change the column name as required.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Solution SupplierHi arimoldi ,
Yes, if you right click on the Activity column in Power Query and select 'Unpivot Other columns', this should achieve what you need.
If you 100% need to show the dates with empty values, I'd suggest populating the blanks as zeros before doing the unpivot. Not being able to see your pbix model, I don't know the context in which you are using this, but assuming a FACT table, the empty values not appearing after the unpivot shouldn't matter if you have a date dimension table your end users are filtering with in your end report.
Hope that helps!