Stacking Measures Vertically

[nickbeltran7]

Hello! 

I have the following measures: 

Revenue = (SUM('Revenue'[Revenue]))

Quantity = CALCULATE(SUM('Revenue'[Quantity]))

Budget Revenue= SUM('Budget'[Budget])

Budget Quantity = SUM('Budget'[Quantity])

I usually display these measures in a matrix, sort of trying to do something similar to an Excel report. However, I am looking to stack revenue and quantity vertically in one column as values and have another value column for budget revenue and budget quantity. I have already played with switching values to rows in the matrix, but I still haven't been able to achieve the layout I want. If someone could help me with this, it would be appreciated.

This is how it looks like right now.

This is what I have done so far switching values to rows.

And this is where I am trying to get.

Thanks,

[lbendlin]

looks like you need to create buckets for Actuals and Budget, and then put that below the months in the column hierarchy.

[Greg_Deckler]

@nickbeltran7 You use a disconnected table for that and a single measure that determines which measure to display:

(1) The New Hotness (Custom Matrix Hierarchy) - Microsoft Fabric Community