Forum Discussion

Peter_23's avatar
Peter_23
Advocate 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...
  • Ritaf1983's avatar
    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.