cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tabuzahra Regular Visitor
Regular Visitor

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

 

 

2019-03-10_12-44-11.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Multiple Columns Pivot Table

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



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




View solution in original post

2 REPLIES 2
Highlighted
Super User
Super User

Re: Multiple Columns Pivot Table

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



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




View solution in original post

tabuzahra Regular Visitor
Regular Visitor

Re: Multiple Columns Pivot Table

Thank you so much

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (3,696)