Forum Discussion

Jamesp435's avatar
Jamesp435
Icon for Advocate I rankAdvocate I
5 years ago
Solved

Formula to get a table visual...

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 

Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    5 years ago

    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.

3 Replies

  • v-kkf-msft's avatar
    v-kkf-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    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.