Allow users to highlight entire rows in a table based on a specific text. Example: Highlighting Apple Inc. in a table with a list of company names, sales, and units. Or highlighting the rows for all...
So this may not be what the original post was about, but some have commented about this specific request I had also. Just wanted to share my hack. I analyze large volumes of text (infrastrure bill) and can highlight rows of sentences based on keywords. This is just due to how the data is structured. A simple csv file with matching keywords to each sentence. But I wanted to highlight with a bold font color, the actual keyword found within the sentence. I'm using the HTML visual and hacked together the text to display by using the following: 1. Custom column that concats some html for the font color of the keyword found, i.e. & [keyword] & 2. Custom column that converts each sentence row into html, i.e.
& [sentence] &
3. Then I add three custom columns splitting the text and keyword html rows. First, Left Text = LEFT(Infrastructure2021[html], SEARCH(Infrastructure2021[keyword],Infrastructure2021[html],1,0)-1) 4. Then get the number of characters for the Right Text, which has to be pretty complex of course: LenLeft Text = (LEN(Infrastructure2021[html]) - LEN(Infrastructure2021[Left Text])) - LEN(Infrastructure2021[keyword]) - 1 5. Now I can get the right text: Right Text = RIGHT(Infrastructure2021[html], Infrastructure2021[LenLeft Text]) 6. Then I just concat my three columns with spaces in between to generate valid html that highlights each keyword. Highlighted Text = Infrastructure2021[Left Text] & " " & Infrastructure2021[fontColumn] & " " & Infrastructure2021[Right Text] I just add this column to the HTML visual and it displays each rows keyword with the bold blue font color!
