Power BI Matrix Customize Columns

[Anonymous]

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

This is what i want to present on the Matrix Visualization

[amitchandak · Accepted solution]

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

[v-diye-msft · Accepted solution]

Hi @Anonymous 

Let me know if you'd like to get this one:

Pbix attached.

[amitchandak · Accepted solution]

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