Forum Discussion
complex mattrix
Hello,
does anybody know if is possible to build in power BI a mattrix like below, where there are multiples rows/columns?
thanks in advance
Luis
3 Replies
It should be easy to create the hierarchy on the left side on the Rows by simply dragging the appropriate fields in the correct order.
But as far as creating the "score 1 ... score4" in the Column titles, no. All four values are under each Month column header with a number in green next to it. What does that represent?
If we had a sense of what information you are trying to convey to your audience, we may be able to find some other visual style to make that happen.
These colors are as any text could be there, they should be more levels like subcat1111, 1112, 1113 , 1114, actually what I am trying to do is to build a mattrix where not all the columns have the same levels, for instance
Cat3 has initially 1 subcat (sub_cat31) and this sub_cat31 each have 4 leveles of subcat.
Cat1 has 2 subcats, but subcat11 has only subcat111 and subcat12 has 3 subcats
Subcat111 has 4 levels more: yellow,green.red.n/a
Subcat121, 122, 123 do not have more levels
Then 1 colum name target, and other column named month which could have like 2 subcolumns
Hi luis_pflucker ,
Sorry, so far, to my knowledge, this may not be achieveable.
You can submit an idea for it at Home (microsoft.com) and wait for users with the same needs as you to vote for you to help make it happen as soon as possible.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
