Forum Discussion
Stacking Measures Vertically
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,
2 Replies
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
looks like you need to create buckets for Actuals and Budget, and then put that below the months in the column hierarchy.
