Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
  • 1.  Finding and replacing words in sentences

    Posted May 13, 2022 06:48 AM

    I have sentences (English and French) and I have specific words in a vocabluary.

    I would like to highlight words in the english sentences when they are in the vocabluary and I would like to highlight the whole French sentence when there is a vocab match in the english one.

    I want to do this with the help of an HTML visual.

    I transformed my vocab column to look like this: <mark>word</mark> so If there is a match I would like to replace the specific word(s) in the sentences with the formatted words.

    With the french sentences I might make a new formatted column and I would like to replace the whole value to the formatted one If there is a match. ( I guess finding the sentences with a match and giving it a prefix and a suffix would be less memory and computing consuming, but i'm not sure)


    We made a solution for words, however we did It in M and we need to do it in DAX on the fly. (With Text.Replace)


    Thank you in advance for your help!


    Kind regards,

    Zoltán Tóth

  • 2.  RE: Finding and replacing words in sentences

    Bronze Contributor
    Posted May 17, 2022 03:43 AM
    This might get you half way :


    James Watts
    Business Intelligence Analyst