Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Power BI Matrix Customize Columns

Is there a way in Power BI Matrix that can do the following?

This is my data.

CategorySizeSpecialtiesAmount
A15Beta50
B15Beta50
C10Gama50
C10Gama50

 



This is what i want to present on the Matrix Visualization

Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , I doubt it possible directly.

    Maybe you create a table like this and try

    Take care of data types

    union(
    summarize(table, table[Category], table[Specialties], "Amount",sum(Table[Amount])),
    summarize(table, table[Category], table[Size], "Amount",sum(Table[Amount]))
    )

     

     

     

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Anonymous , I doubt it possible directly.

    Maybe you create a table like this and try

    Take care of data types

    union(
    summarize(table, table[Category], table[Specialties], "Amount",sum(Table[Amount])),
    summarize(table, table[Category], table[Size], "Amount",sum(Table[Amount]))
    )