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,