Create multiple matrices from one data source and have them automatically arranged in the report.

Hi  mingchao ,

As far as I know, Power BI matrix can't realize this function directly based on your data for the time being, because in the matrix, unless the whole row or column is empty, this empty value will be removed, if there is a value in the middle, then it will be shown in all, and the matrix is to aggregate the data with the same condition, so the duplicates will be shown in only one (e.g. formname=A, aesttimkraw=1, because it's a text format, it will be shown only in one with the same value)

You can consider changing the data format to make [Attribute] into each column to prevent the data from not displaying because of the same condition, you can add an [index] and then merge the [index] and [Attribute] to form a new [Attribute], and then Unpivot Column afterward:

You can then create three matrices with the corresponding columns:

Best Regards,

Liu Yang

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