4 Replies Latest reply on Jul 3, 2017 3:19 AM by Sanket Kelkar

Highlight entire row in a text table

Sanket Kelkar Jun 28, 2017 8:07 PM

Hi All,

I am creating a competitor analysis and need to show my organisation's performance VS other organisations. I simply have a text table with 10 rows and 1 column which shows total sales in column and organisation name in rows. Now I want to highlight the ENTIRE row at which my organisation is present. I can highlight the sales value but I want entire row including name and sales value to be highlighted.

Please refer screenshot from Sample Superstore data. How can I highlight entire first row ?

Can someone please help ?

TIA,

Sanket K

1. Re: Highlight entire row in a text table

Amit Narkar Jun 29, 2017 12:40 AM (in response to Sanket Kelkar)

I can think of multiple ways to achieve this.

1. Using place holders in your visualization so you can apply color mark to individual field as discussed in
https://www.interworks.com/blog/ksloan/2015/01/07/row-level-highlighting-tableau

2. Another easier way to highlight just your row is using calculated field along with row banding.
as in below

where calculation field is just to identify your row. Unfortunately with this you can have your row either at top or bottom of the visual.
Like Show 0 Likes(0)

Actions
2. Re: Highlight entire row in a text table

Sanket Kelkar Jul 3, 2017 1:57 AM (in response to Amit Narkar)

Hi Amit Narkar
I have created a calculation1 field as - if [NAME] = "ABC Corp" then 1 else 0 end

Now I am not sure how to use it in row banding, can you help ?
Like Show 0 Likes(0)

Actions
3. Re: Highlight entire row in a text table

Amit Narkar Jul 3, 2017 2:00 AM (in response to Sanket Kelkar)

put is as a first field in rows shelf(discrete) then sort it using descending order. ABC Corp would appear as first row. Set band size as one for row formatting with same shades for header and pane. as shown in earlier images.
Like Show 0 Likes(0)

Actions
4. Re: Highlight entire row in a text table

Sanket Kelkar Jul 3, 2017 3:19 AM (in response to Amit Narkar)

Hi Amit,

Thank you for your help ! I could successfully implement this solution but as you said, my row has to be at top or bottom. Also it is putting colour on all other rows except my row and it is not looking good.

I checked the other link that you had referred and did not find any solution to highlight the entire row.

Do you have any other workaround for this ?
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

Highlight entire row in a text table

1. Re: Highlight entire row in a text table

2. Re: Highlight entire row in a text table

3. Re: Highlight entire row in a text table

4. Re: Highlight entire row in a text table

Actions

More Like This