Forum Discussion

Peter_23's avatar
Peter_23
Icon for Advocate V rankAdvocate V
2 years ago
Solved

Dealing matrix visual

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 FirstValueTextCol...
Need Help
Show and Tell
Tips and Tricks
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.