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
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
Icon for Microsoft Employee rankMicrosoft 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