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
Microsoft Employee
8 years ago

Hi isabella2003199,

 

Please share some sample tables, including table structure and detailed records to help us better understand your requirement. Is above image your desired output? Do you want a matrix visual to display data?

 

Regards,

Yuliana Gu

isabella2003199's avatar
isabella2003199
Frequent Visitor
8 years ago

Hi evryone,

 

excuse me if I was not totally clear. I have a document with several chapters as for example:

 

Chapter 1

Chapter 2

Chapter 3

 

I have different actors, as:

 

Rob
Bob

Tod

 

Each actor has to say if he is Compliant (C), Not compliant (NC) or partially compliant (PC) to each chapter of the document. The resulting table will be like this:

 

                            Ch1       |           Ch 2           |          Ch3          |

 

Rob                      C                         C                          NC

Bob                      NC                      PC                         C

Tod                      C                         NC                        C

 

On the slicer, selecting the name of actors, I want to plot only the chapters with the NC or PC values, hiding the header of the chapters of the table with C values. As for example, i I select Tod:

 

                                               Ch2

Tod                                          NC

 

 

 

Thank you,

 

Isabella

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft 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
        Microsoft 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