Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi all,
I am trying to add measures to the Rows section of a matrix and this isn't working. Here is the view I'm trying to get to:
The three values for 'Category' are already created as measures. I have Year/Month on a date table, and I'd like to show the measures and Year on Rows, with the months shown on the columns. Is this possible?
And yes, I've already tried Show on Rows and it does not fit this requirement:
Thanks!
Solved! Go to Solution.
@garynorcrossmmc , Measure before dimension is only possible when you convert measure to rows too.
Means unpivot the data
column header grouping
https://www.daxpatterns.com/dynamic-segmentation/
https://community.powerbi.com/t5/Desktop/Matrix-Display-Values-above-Columns/td-p/256905
As far as I know, the built-in method is only "Show on Rows ". I'm afraid there are no other methods to meet your needs.
@garynorcrossmmc , Measure before dimension is only possible when you convert measure to rows too.
Means unpivot the data
column header grouping
https://www.daxpatterns.com/dynamic-segmentation/
https://community.powerbi.com/t5/Desktop/Matrix-Display-Values-above-Columns/td-p/256905
User | Count |
---|---|
89 | |
73 | |
69 | |
65 | |
56 |
User | Count |
---|---|
97 | |
92 | |
85 | |
74 | |
68 |