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.
Anonymous's avatar
Anonymous
Not applicable
4 years ago

amitchandak,

Actually this is what I would like to prevent to happen:

- Totally folded:

 

- Second level:

 

- Third level: Okay! This is how I think it should looks like. Business Area and Audit Area doesn't have any comment, so it should not show any comment when the matrix is folded.

 

 

 

 

 

Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
4 years ago

Anonymous 

You can keep all three columns in the ROWS section of the matrix visual. I think you have inserted the Comments in the Values section.