Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
109 | |
89 | |
76 | |
67 |
User | Count |
---|---|
125 | |
111 | |
100 | |
83 | |
71 |