Matrix Row Total

[Anonymous]

I am trying to create a matrix to display receipts as a percentage of total billings.

The rows are grouped by billing month.

The columns are grouped by receipt month.

I can successfully compute and render the desired value throughout the matrix, the percentage of receipts/billings for a given billing and receipt month combination.

(Sample at bottom)

Now, my question is how to display the sum of billings for a billing month on the left as a total? The client wants to be able to visually contextualize the percentages to a hard dollar total.

Thanks.

Sample

[Greg_Deckler]

@Anonymous Seems like a case for custom matrix hierarchy:

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

[Anonymous]

Looks like you are probably right, Greg. I assumed it would be a bit of a coding chore, but I'm up for the challenge.

Thanks for the advice, and I will mark as a solution once I successfully implement the concepts.

[Greg_Deckler]

@Anonymous You could also do it the old fashioned way where you put the measure or what not in the Columns and then manually shrink all of the multiple duplicate columns that generates but it usually looks bad and messy. There might be a custom visual that allows you to do it cleanly as well.