Multiple result in one cell (matrix)

[Anonymous]

Hi everyone,

I would create a matrix with multiple results in each cells.

MyTable (for exemple) :

TrainingDay     Trainers    Status      TrainingLabel

05/07/2018      Jeff          Validated  AwesomeStuff

05/07/2018      Jeff          Option      **bleep**tyOne

10/10/2018      Jeff          Option      AwefullThing

06/08/2018      Mike        Validated  CrazyDay

...

I would like this result (Matrix) :

Trainers      05/07/2018                    06/08/2018             10/10/2018

_______________________________________________________________________________________

Jeff             AwesomeStuff (in red)                                   AwefullThing (in yellow)

                  **bleep**tyOne (in yellow)

_______________________________________________________________________________________

Mike                                                  CrazyDay (in red)

_______________________________________________________________________________________

...

And sometimes, a training may be longer than one day.

For help, I got one measure with a swith formula to color a cell.

Do you know how to do it?

Thank you all,

[v-cherch-msft · Accepted solution]

Hi @Anonymous

You may use below measure to get the matrix. But i'm afraid it's impossible to set conditional formatting for different rows in one cell. Here is the document Conditional formatting in tables for your reference.

Measure =
CONCATENATEX (
    DISTINCT ( mytable[TrainingLabel] ),
    mytable[TrainingLabel],
    UNICHAR ( 10 )
)

Regards,

Cherie

[Anonymous]

Awesome!!!

Thank you! That's working!

For conditionnal formatting, I could find an issue only to color the font (instead the cell).