Forum Discussion

Abhaykumar's avatar
Abhaykumar
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago
Solved

How to build matrix with labels

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?

Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    8 years ago

    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

1 Reply

  • v-cherch-msft's avatar
    v-cherch-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    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