Forum Discussion

YonghunLee's avatar
YonghunLee
Helper I
6 years ago

Matrix desing like Excel

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)

 

Need Help

3 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    6 years ago

    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.

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

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

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    6 years ago

    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