Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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.  ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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's avatar
lkalawski
Resident Rockstar
5 years ago

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! 😀