Forum Discussion

yashish68's avatar
yashish68
New Member
7 years ago

Table/Matrix layout

Hello,

 

Can you please help to create the below table layout in power bi.

 

  

 

Thanks in advance for any assistance....

Need Help

3 Replies

    • yashish68's avatar
      yashish68
      New Member
      7 years ago

      Hi v-yulgu-msft ,

       

      Thank you for your reply.

       

      In the attahced screenshot, GU, SAPOMID and  Client Name are columns present in database where as Overall, Offshore, Local CD& D, C&M are calculated fields based on Solution CCI% and ADR$ columns respectively.

       

      I just want to know whether the table/matrix layout as shown in screenshot is possible or not.

      Please let me know if there is any workaround for the same.

       

      Thanks & Regards,

      Ashish Yadav

       

      • v-yulgu-msft's avatar
        v-yulgu-msft
        Microsoft Employee
        7 years ago

        Hi yashish68,

         

        A Matrix visual might meet your requirement. Also, I think instead of calculated columns, create Overall, Offshore, Local CD& D, C&M via measures would be better. You can place  GU, SAPOMID and Client Name in "rows", place Solution CCI% and ADR$ in "columns", and place those measures in "values".

         

        Regards,

        Yuliana Gu