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 ...
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

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