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

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

mingchao — Mon, 11 Mar 2024 03:58:21 GMT

Hi team , Is there any way in Power BI and Power BIreport to achieve my requirements as follows?

I have a data A and I want to create different matrices based on the Form column and display them separately in the report, instead of switching through the slicer. I want them to be arranged in sequence. As shown in the figure below, please note that I have many different form values.

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

Anonymous — Tue, 12 Mar 2024 02:45:34 GMT

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

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

mingchao — Wed, 13 Mar 2024 05:54:21 GMT

Thank you for you reply，thank you for your answer, but currently I am facing a problem where there are many different formnames and a large number of attributes. Manually adding columns would be a huge workload.

Also, I have a question. Do we have a way to customize the column order in the table, such as sorting by other columns.