Forum Discussion

msommerf's avatar
msommerf
Helper III
5 years ago
Solved

Vertical Text Table Visual

Hi, Please can somebody help me find a visual to suit my requirements.

 

I have a table of data which has vehicle fleet numbers and the week number in which they are to be serviced:

 

 The requirement is to produce a table/matrix which displays the vehicles fleet number in the week column for which they are due a service:

 

Is there a visual in BI that will allow me to display the data as shown?

Any assistance appreciated.

Need Help
Show and Tell
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    You can just use the matrix visual.  Put Week Number in for Columns and use this measure in the Values.

     

    Fleet List = CONCATENATEX(VALUES(Table[Fleet Number]), Table[Fleet Number], "
    ")

     

    Note there is a carriage return in the measure between the quotes.  Use Shift+Enter to do that if needed.  Replace Table with your actual name of your table.

     

    Regards,

    Pat

2 Replies

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee
    5 years ago

    You can just use the matrix visual.  Put Week Number in for Columns and use this measure in the Values.

     

    Fleet List = CONCATENATEX(VALUES(Table[Fleet Number]), Table[Fleet Number], "
    ")

     

    Note there is a carriage return in the measure between the quotes.  Use Shift+Enter to do that if needed.  Replace Table with your actual name of your table.

     

    Regards,

    Pat