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 of Apple Inc.'s products in a list of items, sales, and units.
9 Comments
- Excellent idea, this feature could be very useful in many different projects.
- waaaaaiting.....
- If it could highlight specific text, as appose to the entire cell. That would be amazing! As an example just highlight "Apple" out of "Apple Inc."
- would love to see this
- Yes please, too redundant to select each column and highlight to highlight an isolate row after having to create a condition
- 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! I just want to highlight a cell based on text, but can also see the value in highlighting a row.
A fast simple (very simple) solution is to use CTRL + F in the browser window and enter a search term. This will highlight any text displayed in your visuals (textual data of course). I have long narratives that I use the search tool on and then hit CTRL + F to find my keyword in the result.
Until there is an 'official' better solution, this is an easy work around.
- Status added:Needs Votes
