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, partially compliant or aknowledged). Basing on a slicer on the names of these people, the table has to readapt showing me only the coloumns that are not compliant (NC) or partially compliant (PC).

 

 

So for example if I select on the slicer Matthew, I would like the table to adapt hiding the chapters that are compliant for him and showing me only the coloumns that are NC or PC.

 

Any ideas?

Thank you

 

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

7 Replies

  • mattbrice's avatar
    mattbrice
    Solution Sage
    8 years ago

    Some sample data would go a long way in helping with this. As is no info on table structure or model design so anyone would be guessing. 

     

     

  • 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 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