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.
Super UserHi TejuCH_99
I am sure you know unpivot function in Power Query which is going to produce your required output since your title says "unpivot".
I attach pbix file.
Hi, thanks for your response. I know Unpivot does that, but I don't have company name in the same table in my dataset to select for unpivot, so company name is from another table, which will be used in a slicer to sort. I just have provider names as columns which should be listed in an another slicer to filter. So, for example my below table is shown with company names and providers, but I want them to be shown vertically as said above
My data set . Also, I have few more additional columns in provider table, but want to create a slicer with just provider columns AB, CD, EF, GH, IJ.
So, I want to create 2 things now, one is a slicer using the provider columns, and then in below table when we select the company name, it should be shown vertically. Hope I'm clear this time. Thanks for your help!