Table Creation

[Anonymous]

I am looking to create a table based on an input of data that I have and need it to be able to change based on the project selected. See the screenshot below for example of what I'm looking to do. 

(CURRENT TABLE INPUT)
Project ID	Project Title	Phase 1	Phase 2	Phase 3
1	Project 1	1/1/2020	2/1/2020	3/1/2020
2	Project 2	5/1/2020	6/1/2020	7/1/2020
3	Project 3	8/1/2020	9/1/2020	9/15/2020
4	Project 4	10/1/2020	11/1/2020	1/1/2021
Desired Output; want to be able to change selected project
Project 1	(sample 1)
Phase	Date
Phase 1	1/1/2020
Phase 2	2/1/2020
Phase 3	3/1/2020
Project 2	(sample 2)
Phase	Date
Phase 1	5/1/2020
Phase 2	6/1/2020
Phase 3	7/1/2020

[Anonymous · Accepted solution]

Hi @Anonymous ,

It is suggested to try the following operations in Power Query Editor.

1.Select Project ID and Project Title columns, and select Unpivot other columns.

2.Rename the new columns.

3.Then select Close&Apply and create these visuals. Then you can select the Project ID through the slicer to display the output.

You can check more details from here.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lkalawski]

Hi @Anonymous

The first thing you should do is unpivot Phase data:

Select 3 columns and click Unpivot Columns in the Transform tab. Then change the name of column Attribute to Phase.

Next step is to create matrix with slicer. Add new slicer and put in the Field Project Title.

Add Matrix visual and to the Column field add Phase column and to the Value add Value column (change name to "Date).

The result:

_______________
If I helped, please accept the solution and give kudos! 😀

[amitchandak]

@Anonymous , Unpivot the data and display in the matrix

https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/

On matrix try Show on Row

https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/