Showing results for 
Search instead for 
Did you mean: 
jsteele58 Frequent Visitor
Frequent Visitor

adding column to matrix

 I have created a matrix (see photo) that shows a project manager (in the example it is Alex Farrow), below that it is a list of projects he is working on. The columns are the months of the year and the values are the number of days he is working on each project.


Project managers are a group so I can drill up to see all project managers and then drill down into each of their list of projects.


Each project manager has a target number of days they should be working on projects each month. Ideally this should be shown in a column that appears between the list of projects and the column for january with the value appearing in the row next to Alexs name. Failing that, if the column appears and lists the target next to every project that would also be fine.


However, if I add as a column it appears 12 times alongside each month. 


How can I add single columns of data into a matrix without them being a group or repeating throughout the table?



Super User
Super User

Re: adding column to matrix



I don't think that is possible in PowerBI desktop.  However, this can be done in Excel using the PowerPivot.

AbdulkareemALha Frequent Visitor
Frequent Visitor

Re: adding column to matrix

have you found a solution ?

Helpful resources

Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 285 members 3,037 guests
Please welcome our newest community members: