cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
yashish68 Frequent Visitor
Frequent Visitor

Table/Matrix layout

Hello,

 

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

 

 Table_Layout.JPG 

 

Thanks in advance for any assistance....

3 REPLIES 3
Community Support Team
Community Support Team

Re: Table/Matrix layout

Hi @yashish68,

 

It depends on how is your source data structured and how is the value calculated.

How to Get Your Question Answered Quickly

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
yashish68 Frequent Visitor
Frequent Visitor

Re: Table/Matrix layout

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

 

Community Support Team
Community Support Team

Re: Table/Matrix layout

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 

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.