Why a column doesn't work in Values Box in Matrix

[Anonymous]

I have following SQL Tables and Columns:

-Issues: Company Name

-Company: Name

I have done a one-way relation between Issues and Company SQL Tables. The relation is correct.

In Power BI I have made a Table Visual where I have used Company:Name as Value, and it works fine.

BUT, if I change the Visual to Matrix, and use the Company:Name as a Value there, it doesn't work anymore. It works as a Row.

Any clue for this malfunction?

[amitchandak · Accepted solution]

@Anonymous , when want to group data in the matrix, it should be in a row or column. It can not be in values. Values in the matrix need to be summarized https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual