Forum Discussion
Solved
Custom Matrix help
Hi, I have created a Matrix in Power BI where I have a list of components as rows and different tests as columns, and I show the concentration values for each test and component as shown below, w...
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
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