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 10 days ago

    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 6 days ago
    This might get you half way :

    https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa200002426?tab=overview

    ------------------------------
    James Watts
    Business Intelligence Analyst
    ------------------------------