Forum Discussion
Unpivot/Pivot
You can do table transformation on PowerQuery. Particularly the "Unpivot". Here is from the sample you have given.
Hi TejuCH_99
AngeloParana DataNinja777 Thank you very much for your patience in responding! I think the options you offer make a lot of sense.
TejuCH_99 If you still have questions, allow me to add something here.
Make sure there are no relationships between your tables before you unpivot. Because of the existence of relationships, it is possible that your operation will fail.
If you don't want other columns to affect your data, then please don't select these unwanted columns before you unpivot. For example, you can select several columns for unpivot as shown in the figure:
You can get a table like this.
Create a relationship.
Create the slicer you need. For example, company and provider:
I hope this helps.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi TejuCH_99
AngeloParana DataNinja777 Thank you very much for your patience in responding! I think the options you offer make a lot of sense.
TejuCH_99 If you still have questions, allow me to add something here.
Make sure there are no relationships between your tables before you unpivot. Because of the existence of relationships, it is possible that your operation will fail.
If you don't want other columns to affect your data, then please don't select these unwanted columns before you unpivot. For example, you can select several columns for unpivot as shown in the figure:
You can get a table like this.
Create a relationship.
Create the slicer you need. For example, company and provider:
I hope this helps.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.