Vertical Text Table Visual

[msommerf]

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.

[amitchandak]

@msommerf , refer to this video of creating a list. see if this can help

https://www.youtube.com/watch?v=WSnB5y2JXv8

[mahoneypat · Accepted solution]

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