Dealing matrix visual

[Peter_23]

Hi Power BI users, I'm developing a matrix visualization with rows  (categories) and values (text columns), it don't use colmns, so  when I drag the text column to values it show me FirstValueTextColumn,e.g 1, 1,2..etc;   instead of the only text value, e.g. (blue laptop), so its possible to change this issue.

Thanks in advance.

[Ritaf1983 · Accepted solution]

Hi @Peter_23 
A matrix is like a graph / pivot table ...all values that you want to put as a "value" should have an aggregation.
The option "don't summarize" is available only for the tables.

From the last version, we have an option for tabular form, you can put your category as "next" level hierarchy and then you will get something like :

The pbix with example is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

[RossEdwards]

The Matrix Visuals "value" area requires values to be aggregated, as in summed, averaged etc.

If you want all of your text displayed, you would need to use the table visual, or put the text within the row headers.

Depending on what you are wanting to do with your Matrix, you might find that Power BI Paginated might produce a matrix table more down the line of what you are hoping.  It can connect to your data model and use all of your tables and measures.