Limit of Columns in Matrix Object

Question

Hello,&nbsp;I have one question. When I try to create a matrix object with two dimensions (one by rows and the other by columns), the object don't show me the 100% of values contained in the dimension 2 (columns). My question is, The matrix object in Power BI have a default restriction of showed values in columns ?&nbsp;Like this example:&nbsp;&nbsp;In my dimension 1, I have 3 values, the matrix show me 3 values, so this is ok.In my dimension 2, I have 50 values, the matrix show me just 43 values, so the object truncate my value columns.&nbsp;Thank you for your answers !.&nbsp;&nbsp;&nbsp;&nbsp;

andre · Answer

the matrix will only show you values for all permutations of Dimension 1 and Dimension 2 where there is an actual data in the fact table that links them both

aldoh · Answer

All values in dimension # 2 have cross-values against dimension # 1

andre · Answer

there should not be any restrictions that i am ware of... I would take a look at the logic or data

aldoh · Answer

I create a PBIX file with this Excel File.The Matrix shows me this message:&nbsp;

andre · Answer

ok, that makes sense, I did not understand your question before... if you have too many values in the&nbsp;column that you use as&nbsp;columns for a matrix, then you can get this message.&nbsp; I don't believe that limit is documented.&nbsp;&nbsp;Generally speaking, if you have more than a handful of columns in the matrix, the matrix becomes not very user friendly from the reporting perspective.&nbsp;&nbsp;Is there a reason to show that many&nbsp;columns in a visual?

Forum Discussion

Limit of Columns in Matrix Object

6 Replies

Related content

Matrix Column Widths

Matrix column based on other matrix columns

Matrix column not grouped

Matrix table column Hide

Responsive Matrix Visual Object