Ethan on 14 Jun 2017 05:22:54
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.
- Comments (8)
RE: Conditional Formatting - Highlight Specific Text
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.
RE: Conditional Formatting - Highlight Specific Text
I just want to highlight a cell based on text, but can also see the value in highlighting a row.
RE: Conditional Formatting - Highlight Specific Text
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!
RE: Conditional Formatting - Highlight Specific Text
Yes please, too redundant to select each column and highlight to highlight an isolate row after having to create a condition
RE: Conditional Formatting - Highlight Specific Text
would love to see this
RE: Conditional Formatting - Highlight Specific Text
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."
RE: Conditional Formatting - Highlight Specific Text
waaaaaiting.....
RE: Conditional Formatting - Highlight Specific Text
Excellent idea, this feature could be very useful in many different projects.