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. Category Size Specialties Amount A 15 Beta 50 B 15 Beta 50 C 10 Gama 50 C 10 Gama 50 ...
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]))
    )

     

     

     

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]))
)