Visualisation option that allows for text format data to be used as table/matric values.

[maracles]

Hi,

I'm trying to create a table visualisation that is all text values. The row and column headers are text, but then so are the value completing the table. For an illustration of my data see the image below:

My column headers are 'Departments'. Under each of those departments I want to list the 'Roles' within each department. My data is set-up so that each role only belongs in one department. 

The table below is close to what I want but it is using 'First' value whereas I want it to list every value. 

Thanks for suggestiosn .

[maracles]

@amitchandak I have actually tried your solution and it is working. Is there though a way of getting each value on it's own row, rather than having them all in one row but with linebreaks? 

For anyone else looking for this solution you can add Line Breaks with & UNICHAR(10) 

[amitchandak · Accepted solution]

@maracles , Not very clear. But you can create measure using concatenatex and use that

Concatenatex: https://www.youtube.com/watch?v=du2HSEzng2E&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=43

concatenatex(Table, Table[Column], ",")

[maracles]

Thanks @amitchandak - sorry it wasn't clear. If this helps I'm trying to produce a Matrix like the below:

My data is in two tables:

1. Departments
2. Roles

The data relationshipis one to many, with each Role linking to only one Department, but each Department having many Roles.

I just figure out to have the Roles as the value in the table.  Does ConcatenateX help in this scenario?