Forum Discussion
Table Creation
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 | ||||
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.
3 Replies
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/
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! 😀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.
