How to Create Pivot table - Power BI Desktop Tips and Tricks (33/100)

What is Pivot option in Power Query
Pivot Option in Power query
How to transform values in rows into columns in Power Query / Power BI
Importance of PIVOTING Data in Power BI

Source Table

#PowerBI #PowerBIDesktop #PowerBITutorials

Complete Playlists

[sattimama]

Nag, Its really helpful for those who want to practise with data. Thanks for sharding the data files also.
1)Make two copies of table
2) From the first copy Remove the CompletionDate column and create a pivot table
3) From the second copy remove the StartDate column and create a pivot table

4) Merge both the Queries into one table which has Project ID with StartDate and Completion Dates at each stage.

[jayantghadei]

I have applied below steps and got excepted result .

1- Open Power Query Editor.
2- Select both Start Date and Completion Date Columns and apply Unpivot Columns transformation.
3- Select both Stages and Attribute (newly created column from 2nd step) and apply Merge columns transformation (under transformation tab).
4- Now Select Merged Column (created from 3rd step) and apply Pivot Column transformation (Select values Column = Value and Do not aggregate under advance options)

[kartik-wijv]

Hi Nag, Yes, its good to have participation from viewers... I have achieved by using below 3 steps.
S1: Referenced Base table as 'Startdate' tbl, and removed 'completiondate' column and pivoted 'stage' column.
S2: Referenced Base table as 'Completiondate' tbl, and removed 'startdate' column and pivoted 'stage' column.
S3: Merged as New Query 'Startdate' tbl with 'Completiondate' tbl. and renamed as 'CombinedDates' tbl. achieved desired output.
please suggest further if any...

[deebandheiveehan]

Hi Nag,

Step1 : In Power Query Editor, merged these columns (PlannedOrActual and Stages) using delimiter
Step2 : merge again these two columns (StartDate and CompletionDate) using delimiter
Step3: Pivot those merged columns from rows to columns, Now 5 columns will be generated
Step4 : Split those 5 columns into each as StartDate and CompletionDate using delimiter, Now(5*2) 10 columns will be there in the power query viewer.

[erinfield]

1) select both date columns
2) unpivot
3) merge "Stages" and "Attributes" columns with space as delimiter
4) select "Stage and Attribute" column
5) pivot (under advanced, select Maximum for the date)

[zflora]

Hi Nag, where can I find the solution?

[mostafahwafy]

could you answer me on this question plz:
i want to highlight top 3 in pivot chart with every drill down is that possible ?
thank you for all your information you sharing🤗

[priyankadubey]

to be honest, i tried but did not find solution, and then i tried what siva has done, finally got it . Thanks sir, thanks siva

[prateekmanocha]

Just by Transpose Table, we can have 5 columns of each project with both dates

[gungovardhan]

By using' column from examples'

[abeerschannel]

S1:-- select start and complition date and rightclick then select unpivoted columns

[bidatron]

Hi. Just wondering if you’ve posted the solution to this in a video? Thanks.

[praveennani]

Go to unpivot columns then select unpivot other columns ..

[joanarun]

Proj_ID PlannedOrActual Kick Off StartDate Kick Off CompletionDate Execution StartDate Execution CompletionDate UAT StartDate UAT CompletionDate Go Live StartDate Go Live CompletionDate Maintainance StartDate Maintainance CompletionDate