How do I add extra totals to a matrix?

[DataDave]

I have a dataset which describes effort per project per staff member being presented as a matrix.

User, Project, Effort, TaskType, Date, Region

I've created measures to allow me to use slicers for reporting precentages for periods and regions, and I'd like to only show these measures once as a total per staff member.

ie

User01, Project1Effort, Project2Effort, Project3Effort, ..., Project N Effort, EffortTotal, Measure1, Measure2

User02, Project1Effort, Project2Effort, Project3Effort, .., Project N Effort, EffortTotal, Measure1, Measure2

User03, Project1Effort, Project2Effort, Project3Effort, .., Projec tN Effort, EffortTotal, Measure1, Measure2

I wanted to put the measures in the matrix Rows, but measures aren't allowed.

I don't want them in the Values because I don't want the measures displayed per project - only per row.

Putting them in the Columns causes the actual values to be used as column headers.

I can create a second matrix just for the totals, but they can't be linked so I have to scroll one then the other.

Is there a good solution?

[Greg_Deckler]

@DataDave - There is a "Show on rows" option for Values. It is in the Formatting pane under Values. May work for what you want to do:

[Greg_Deckler · Accepted solution]

Also @DataDave - This might work for you as well:

https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/...

It was invented to solve the problem where you just want extra column totals but not the value in each Column.

[DataDave]

@Greg_DecklerI have used this technique to produce an acceptable report. Thank you.

[DataDave]

@Greg_DecklerThank you for looking into this.

If I had a static (or rarely changing) list of Projects this solution would be great. I guess I'm hoping for a lower maintenance solution.

The "show on rows" option is still going to display all the measures per project, but it will list the projects down the page. I can try to sell it to the higher ups. It's just significantly less dense that a matrix with applied heat map.

[Greg_Deckler]

@DataDave - Can you share some representative sample data and maybe a mock-up of what you are going for? Might be able to come up with something creative.

[amitchandak]

@DataDave , I think you are looking for a Hybrid table to have an extra total column, That is not possible now. I posted an idea for that vote for that. : https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/39773011-hybrid-table

You may have to create all columns and do it. But that will limit how many columns you can have

[DataDave]

This is exactly what I want, but I've got a dynamic list of projects to account for so I can't create columns (unless I want to incur a maintenance overhead).

[amitchandak]

@DataDave , Check out some custom visual

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381971?src=office&tab=Overview

https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals

Seeded one do not support it , vote for the idea