Forum Discussion

isabella2003199's avatar
isabella2003199
Frequent Visitor
8 years ago
Solved

List matrix

Hi everyone,   I have a document with different chapters. Then I have diferent people who have to say to which chapters they are compliant or not (the different option are compliant, not compliant,...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi isabella2003199,

     

    As Chapter values are placed as column headers in Matrix visual, it is not possible to hide/show columns dynamically based on slicer selection.

     

    As a workaround, you can switch the Row and Column fields added to Matrix. Please see below image.

     

    Create a measure. Select Matrix visual, add this measure into visual level filter, set its value to 0.

    Measure1 = IF(LASTNONBLANK('List Matrix'[Value],1)="C",1,0)

     

    Result.

     

    Best regards,

    Yuliana Gu

isabella2003199's avatar
isabella2003199
Frequent Visitor
8 years ago

Hi everyone,

 

chapter 1, 2 and 3 are the coloumns name as Rob, Bob and Tod are the names of the rows. The value are C NC or PC. The table is fixed, I mean I have all the value in the table concerning all the coloumns and all the orws. However, if on the slicer Iselect for example Tod, I do not want to see the coloumn names of the table in which tod is compliant, so the table as to become shorter, not displaying me all the coloumns.

 

I hope I was clear.

Thank you in advance

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

Hi isabella2003199,

 

As Chapter values are placed as column headers in Matrix visual, it is not possible to hide/show columns dynamically based on slicer selection.

 

As a workaround, you can switch the Row and Column fields added to Matrix. Please see below image.

 

Create a measure. Select Matrix visual, add this measure into visual level filter, set its value to 0.

Measure1 = IF(LASTNONBLANK('List Matrix'[Value],1)="C",1,0)

 

Result.

 

Best regards,

Yuliana Gu