How to build matrix with labels

[Abhaykumar]

I want to build a matrix with labels that shows the relationship between each pair of values. Example: Confusion matrix. I have data in a table like below. How can i model this data and add to matrix/any other visual.

Is it possible to have dynamic number of columns, by any chance?

[v-cherch-msft · Accepted solution]

Hi @Abhaykumar

You may try to use Unpivot other columns to create a table. Then create a measure to get the dynamic number of columns. For example:

Measure  = DISTINCTCOUNT(Table2[Class])

You may try to drag the new table’s column to Rows and create measures to compare the values. For example:

1 =
IF (
    SELECTEDVALUE ( Table2[Column1] ) = SELECTEDVALUE ( 'Table2 (2)'[Value] ),
    SELECTEDVALUE ( Table2[Column1] ),
    0
)

Regards,

Cherie