Forum Discussion
Custom Matrix help
I don't know what your data structure is, but based on the screen I can see that the test names are in one column. You can pivot this column, set test values as value. This will give you Test1, Test2, Test3 columns.
Source:
Pivot:
New structure:
This structure will allow you to add these columns to the Values field in the Matrix settings and the Higher column will occur only once.
The result:
Proud to be a Super User.
If I helped, please accept the solution and give kudos!
LinkedIN
Hi lkalawski ,
Thank you for your message. I'm not using DAX code to build the matrix, just standard visualisation graph. Please see below. All variables used are columns with plain numbers (no code) except for the measure which is calculated to change units etc
I see that each of the variable has own higher value, so what do you want to have in the "higher" column? Max, Avg, Sum of all variables?
If yes, then you can create a measures and use All([table]).
Example:
Calculate(Sum(table[Name]), All(table[Name]))
| Proud to be a Super User. If I helped, please accept the solution and give kudos! |
Hi lkalawski ,
I would like the column 'higher' to appear only once in the table vs per variable since the values are the same always.
thanks
Laura
I don't know what your data structure is, but based on the screen I can see that the test names are in one column. You can pivot this column, set test values as value. This will give you Test1, Test2, Test3 columns.
Source:
Pivot:
New structure:
This structure will allow you to add these columns to the Values field in the Matrix settings and the Higher column will occur only once.
The result:
Proud to be a Super User.
If I helped, please accept the solution and give kudos!
LinkedIN