Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Show/hide matrix items with conditional formating

I have a matrix that shows results from a checklist. The matrix is divided in 3 levels, nested in this order: Bussiness Area, Audit Area and Question. I have a comments column that I would like to f...
Need Help
Tips and Tricks
Tutorial Requests
  • ikor42's avatar
    ikor42
    4 years ago

    Hi,

    instead of column "Comment" in the Value box use measure: 

    New Comment = IF (
                                     ISFILTERED ( Checklist[Question] ),
                                     SELECTEDVALUE ( Checklist[Comment] )
                                 )
     
    Should be enough to fix the issue.
ikor42's avatar
ikor42
Regular Visitor
4 years ago

Hi,

instead of column "Comment" in the Value box use measure: 

New Comment = IF (
                                 ISFILTERED ( Checklist[Question] ),
                                 SELECTEDVALUE ( Checklist[Comment] )
                             )
 
Should be enough to fix the issue.
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks ikor42!!

    It worked. I just had to add a different column to ISFILTERED.