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

mattbrice's avatar
mattbrice
Icon for Solution Sage rankSolution 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.