Forum Discussion
Why a column doesn't work in Values Box in Matrix
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?
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
1 Reply
- amitchandak
Super User
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