Forum Discussion
List matrix
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
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