Forum Discussion
Pivot in direct Query
Hi Anonymous ,
Here is my table in Power Query. The only thing I did was to change all columns to text.
Select the flag column. Go to the Transform tab, click on Pivot Column, select Name as the Values Column. Go to the advance options and select don't aggregate. You will see the following.
If this solves your issue, please mark this reply as the solution. Kudos are nice too!
table
Drop each column into a matrix as follows:
for this solution.
If
this solves your issue, please
mark it as a solution. Kudos are nice too!
i want the data to be transpose in the table level but not in the visualization level .
Hi Anonymous ,
Here is my table in Power Query. The only thing I did was to change all columns to text.
Select the flag column. Go to the Transform tab, click on Pivot Column, select Name as the Values Column. Go to the advance options and select don't aggregate. You will see the following.
If this solves your issue, please mark this reply as the solution. Kudos are nice too!
this solution is not working in DirectQuery bro! Nathaniel_C