Forum Discussion

jcastr02's avatar
jcastr02
Post Prodigy
6 years ago

Explicit language - filtering out or flagging

I have a matrix visual showing comments left on a survey from team members.  Is there a way that BI filters or flags explicit comments, I'll have this on auto-refresh so I wouldn't want them to show....
Need Help
v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi jcastr02 ,

 

We can create a table with specific words you do not want to show in the matrix visual called 'Filltered Word', then create a measure as following and put in  the visual filter of matrix, set condition "equal to 1" to meet your requirement.

 

ControlShow =
VAR comment =
    SELECTEDVALUE ( 'Table'[Comment] )
RETURN
    IF (
        CALCULATE (
            COUNTROWS ( 'Filltered Words' ),
            FILTER (
                ALL ( 'Filltered Words' ),
                FIND ( 'Filltered Words'[Word], comment, -1 ) > 0
            )
        ) > 0,
        -1,
        1
    )

 


Best regards,