Forum Discussion

MRHUP's avatar
MRHUP
Frequent Visitor
4 years ago
Solved

How to place an extra column in a matrix (based on a string)?

Hi,   For an assignment I am looking for a solution, hopefully it is possible.... In a Matrix, after a regular count of the number of some  occurrences, I want to add an extra column for clarificat...
column
matrix
Matrix table
  • tamerj1's avatar
    tamerj1
    4 years ago

    MRHUP 

    Sure. But from the format settings make sure you don't select "measure on rows" and you have (compared to the given example) the category on rows and the color on columns. Also what are the empty rows that is shown in the last screenshot?

MRHUP's avatar
MRHUP
Frequent Visitor
4 years ago

Maybe a better picture of this outcome:

 

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Are you having the measures on rows or columns?

  • MRHUP's avatar
    MRHUP
    Frequent Visitor
    4 years ago

    I was only allowed to add the new measure for the A1 - A16 ID's (SELECTEDVALUE ( Table[Id] )) into the value field.

    • tamerj1's avatar
      tamerj1
      Icon for Community Champion rankCommunity Champion
      4 years ago

      MRHUP 

      Sure. But from the format settings make sure you don't select "measure on rows" and you have (compared to the given example) the category on rows and the color on columns. Also what are the empty rows that is shown in the last screenshot?

      • MRHUP's avatar
        MRHUP
        Frequent Visitor
        4 years ago

        Hi, the empty rows are the result of placing the just made measure as a value (with the option "show on rows"), creating the same as in the example:

         

         

         

         

         

         

         

         

         

         

         

         

         

         

        Ha, I de-activated the "show on rows", and now it seems pretty nice (see below)! Not exactly what I'd expected (the Id's are located on some odd places), but I have to check the data for this. Will do that tomorrow. Thank you very much for the advice!