Forum Discussion

tabuzahra's avatar
tabuzahra
Helper II
7 years ago
Solved

Multiple Columns Pivot Table

Hello Everyone,

I have been trying to create a pivot table like shown below, is there any way to do it in Power BI

 

 

 

Need Help
  • MFelix's avatar
    MFelix
    7 years ago

    Hi tabuzahra ,

     

    Just add the fields of your data to rows of the matrix visual.

     

    I'm assuming that you have a table of Projects and a table of tasks, just adapt to your model.

     

    Check PBIX file attach.

     

    Regards,

    MFelix

2 Replies

  • MFelix's avatar
    MFelix
    Super User
    7 years ago

    Hi tabuzahra ,

     

    Just add the fields of your data to rows of the matrix visual.

     

    I'm assuming that you have a table of Projects and a table of tasks, just adapt to your model.

     

    Check PBIX file attach.

     

    Regards,

    MFelix