Explicit language - filtering out or flagging

[jcastr02]

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.  The only thing I can think of would be to use a filter to exclude specific words but wasn't sure if there was something already built in.  

[v-lid-msft]

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,

[amitchandak]

Refer, if this can help

https://docs.microsoft.com/en-us/azure/cognitive-services/text-analytics/tutorials/tutorial-power-bi...