No video :(

How to Highlight an Entire Row in Tableau

Подписаться 8 тыс.

Просмотров 29 тыс.

50% 1

Connect with us!
•Subscribe to the OneNumber Newsletter: onenumber.biz/...
•Follow Eric Parker on LinkedIn: / eric-parker-37513249
Thanks for checking out this video! To learn more, check out our upcoming classes, webinars and office hours here: www.eventbrite...
------
In Excel, you can easily highlight an entire row in a spreadsheet by selecting a row and adding fill to the background of the cells. How about Tableau however? Tableau highlight tables get you close, but one of their shortcoming is they don’t highlight the background of dimensional headers.
If you want to add the highlight color to the background of the dimensional headers as well, you can! It’s going to take a little creativity. Check out this video to learn how you can create Excel-like highlight tables in Tableau!

Опубликовано:

29 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 28

@onenumbertableau Год назад

Need help setting something like this up? Schedule an hour with Eric here: www.eventbrite.com/e/tableau-office-hours-with-eric-parker-tickets-42691995909 Ready to master Tableau? Check out our lineup of upcoming classes! www.eventbrite.com/o/onenumber-15678294163

@ebkepner Год назад

You are a Tableau God. Thank you so much for providing this tutorial! I'll definitely check out your classes.

@onenumbertableau Год назад

Wow, thank you Elisa!

@ashwinigerigenti6888 2 года назад

Thanks a lot. I really struggled a lot to get this workout. Finally found this.

@onenumbertableau 2 года назад

So glad to hear it, thanks for letting us know!

@hassanonnelalab5685 Год назад

Really solid tutorial, thank you

@onenumbertableau Год назад

We are so glad to hear it helped. Thanks for letting us know!

@shoppersdream 8 месяцев назад

Nice, thanks!

@onenumbertableau 3 месяца назад

You're welcome!

@romanvasiura6705 Год назад

Thank you 😃

@onenumbertableau Год назад

You're welcome!

@Data.MadScientist 3 месяца назад

Is there anyway to make the column headers at the end be on top rather than on bottom?

@onenumbertableau 3 месяца назад

Yep! Here's one way to do it: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-mhP70RvWBQE.html&ab_channel=OneNumber-TableauExperts

@OkaroShinn 11 месяцев назад

thank you so much

@onenumbertableau 11 месяцев назад

You are welcome!!

@4abhinavagrawal 2 года назад

How do we resize column width, adding too many columns truncates the text and all columns have the same width by default. Appreciate your help.

@onenumbertableau 2 года назад

Hi Abhinav, that is one limitation of this approach that all columns will have the same width. Could you create a line break to wrap the text? (more on that here: onenumber.biz/blog-1/2017/12/27/char10-the-secret-to-creating-line-breaks-in-tableau-calculations)

@FalconFlyer75 10 месяцев назад

is there a way to Colour an entire row AND conditionally format a column at the same time? lets say I have 4 Regions (North, South, East West), just using Superstore data for this scenario and I have a matrix that shows their Sales and their Profit in 2 columns I have a Paramater that allows me to select 1 of the 4 regions lets say I select North in the Paramater in the Matrix I'd like to highlight the entire row for North to be Blue, but I would also like cell in the Profit Column to be Green if its a profit and Red if its a loss I know how to do these separately (thanks to your videos) but I can't find a way to do them Together, and I really need to for my current job

@onenumbertableau 10 месяцев назад

After thinking about it for a while, I think it might be easiest if you build two different worksheets and format them in a dashboard to look like a single sheet. I cant think of a way to conditionally format Rows and a single Measure column in a multi-measure highlight table.

@FalconFlyer75 10 месяцев назад

@@onenumbertableau I wish I could, the problem is it’s a sizable list and when I export to PDF it gets cut off in a dashboard, In a worksheet this isn’t a problem tableau just breaks it over multiple pages I appreciate u taking the time to answer though, your videos are a great reference

@onenumbertableau 10 месяцев назад

@@FalconFlyer75 The only other option I can dream of is unconventional. You could pivot the Sales and Profit columns in your data source so that you have a column called "Field Name" and another called "Value". If you did that, it would make the data source pretty unusable for other purposes but would help for this scenario. That way you could set up a multi-line IF statement like this. IF [Region] = [Region Parameter] AND (IF [Field Name] = "Profit" THEN [Value] END) > 0 THEN "Green" ELSEIF [Region] = [Region Parameter] AND (IF [Field Name] = "Profit" THEN [Value] END)

@raveendrakumar9926 3 года назад

How to push axis header to top?

@onenumbertableau 3 года назад

ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-mhP70RvWBQE.html

@raveendrakumar9926 3 года назад

how to do hide pin icon ?

@onenumbertableau 3 года назад

Depends on the visual type. Try seeing if you can turn it off with the "Map Options" dropdown. help.tableau.com/current/pro/desktop/en-us/maps_options.htm

@onenumbertableau Год назад

Ready to take your Tableau skills to the next level? Check out our upcoming classes here! www.eventbrite.com/o/onenumber-15678294163

@saiphanindra4081 Год назад

Hello Sir, I have a Table like this ..................Accept...............||...................Reject............. ..........Yesterday | Today......||..........Yesterday | Today..... Book- ...200........100..........||............12...............100....... Shellf.....300.........500.........||...............100................0..... Birds......400..........200........||................12................50... Now I want to highlight with a green background if today is greater than yesterday and I don't want to highlight any of yesterday's value......Thanks...

@onenumbertableau Год назад

It seems like the approach in this video might help: onenumber.biz/blog-1/2022/5/2/how-to-highlight-a-single-column-in-tableau