Matrix desing like Excel

[YonghunLee]

With Excel, I can design table(1) as I want

In power BI, I can make matrix (3), and table (4) with measure(2)

But I can I design exactly like excel?  I have to join (3) and (4)

[v-lili6-msft]

hi  @YonghunLee 

First, you custom couldn't column in matrix visual that means you couldn't join (3) and (4) like excel in power bi. You need to put them into two matrix visual separately.

Second, you could create [% of Retail] and [% of Internet] measure as amitchandak said.

Regards,

Lin

[amitchandak]

@YonghunLee ,

Try two measures like

% of Retail = divide( sumx(filter(Table6, table6[Type]="Retail"),Table6[Amount]),sumx(All(Table6),Table6[Amount]))
% of Internet = divide( sumx(filter(Table6, table6[Type]="Internet"),Table6[Amount]),sumx(All(Table6),Table6[Amount]))

[lbendlin]

You can create independent measures for your categories (Internet, Retail etc) and then add these measures to the Matrix instead of the single value column/measure.  Then create a percentage measure, add that as well, and you are getting close to the Excel functionality.

Warning:  What you are doing is called "Fighting the API".  Don't do that. Embrace Power BI for what it is, don't try to make it behave like Excel.