Formula to get a table visual...

[Jamesp435]

Hi team

In a Power BI data-table I have the following list:

Client	Issue
BT	26/01/21:  Lack of resources
BT	28/01/21:  Cannot get supplies
Vodaphone	27/01/21:  Manpower shortages
BT	29/01/21:  Electrical problems
Vodaphone	30/01/21:  Supply chain problems

On a Table visual I want to condense this to the following 2 x 2 table (Note - I do not want this to be a matrix visual sorry):

BT	26/01/21:  Lack of resources 28/01/21:  Cannot get supplies 29/01/21:  Electrical problems
Vodaphone	27/01/21:  Manpower shortages 30/01/21:  Supply chain problems

Do you know the formula I need to add to be able to do this?

Many thanks 

James 

[v-kkf-msft · Accepted solution]

Hi @Jamesp435 ,

Try the following formula:

Measure 4 = 
CONCATENATEX(
  Test,
  Test[Issue],
  UNICHAR(10)
)

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Jamesp435]

Perfect. 

Thanks for that Winniz

James 

[amitchandak]

@Jamesp435 , I think you have to use Matrix Visual . With Stepped Layout Off

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual