Limit of Columns in Matrix Object

[aldoh]

Hello,

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 ?

Like this example:

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.

Thank you for your answers !.

[andre]

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]

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

[andre]

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

[aldoh]

I create a PBIX file with this Excel File.

The Matrix shows me this message:

[andre]

ok, that makes sense, I did not understand your question before... if you have too many values in the column that you use as columns for a matrix, then you can get this message.  I don't believe that limit is documented. 

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. 

Is there a reason to show that many columns in a visual?

[aldoh]

Thank you for your answer,

It's just a customer request