Proper row data to be picked up in the matrix

[Kopek]

Hi,

I am coming with matrix issue, i have no idea how to adress..

My requirement is to build layer matrix visualization with proper comments in it.

I want to achieve below:

My Data source look like that :

Category	Sub Category	Sub-SubCategory	Value I	Value II	Notes
Main Category	Sub Category I	SubSubCategory I-I	0	0	SubSubCategory I-I Comment
Main Category	Sub Category I	SubSubCategory I-II	1	1	SubSubCategory I-II Comment
Main Category	Sub Category II	SubSubCategory II-I	2	2	SubSubCategory II-I Comment
Main Category	Sub Category II	SubSubCategory II-II	3	3	SubSubCategory II-II Comment
Main Category	Sub Category III	SubSubCategory III-I	4	4	SubSubCategory III-I Comment
Main Category	Sub Category IV	SubSubCategory IV-I	5	5	SubSubCategory IV-I Comment
Main Category	Sub Category IV	SubSubCategory IV-II	6	6	SubSubCategory IV-II Comment
Main Category	Sub Category IV	SubSubCategory IV-III	7	7	SubSubCategory IV-III Comment
Main Category			8	8	Main Category Comment
Main Category	Sub Category I		9	9	Sub Category I comment
Main Category	Sub Category II		10	10	Sub Category II comment
Main Category	Sub Category III		11	11	Sub Category III comment
Main Category	Sub Category IV		12	12	Sub Category IV comment

Could you please help me out finding a proper measure which will take the proper comment to poper line ?

Maybe i should change something in datasource ?

Thanks in advance!

[v-alq-msft · Accepted solution]

Hi, @Kopek 

You may achieve your requirement with matrix visual. 'Category', 'Sub Category' and 'Sub-SubCategory' fields are put in 'Row'. 'Value I', 'Value II', 'Notes' fields are put in 'Values'. You need to set the aggregation for 'Notes' as 'First'.

Result:

Best Regars

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ibarrau]

Hi. The thing about the matrix is that the value must be aggregated. In case of text, you can use MAX/MIN or LAST/FIRST to the text column (NOTES). Create a measure like that MAX('Table'[Notes])

Hope that works.