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

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

Hi isabella2003199,

 

I have a document with several chapters as for example:

 

Chapter 1

Chapter 2

Chapter 3

 

I have different actors, as:

 

Rob
Bob

Tod

 

 

Is this your table structure? Chapter1, Chapter2, Chapter3 are detailed records of a single column or column names?

 

How should I know for example, whether Rob is is Compliant (C) or Not compliant (NC) for Chapter1?

 

Reference: How to Get Your Question Answered Quickly

 

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