No video

How to Highlight a Single Column in Tableau

  Рет қаралды 24,829

OneNumber - Tableau Experts

OneNumber - Tableau Experts

Күн бұрын

About:
Hi! I'm Eric with OneNumber. Thanks for checking out our channel. We appreciate the support! We love to help people with their Tableau problems. Feel free to comment, reach out directly, or check out our upcoming classes and office hours if you want to take Tableau to the next level (www.eventbrite....
Description:
“Can Tableau do conditional formatting?”
Lots of new Tableau users, especially with Excel skills, want to know if they can use Tableau like Excel. Tableau isn’t really designed like Excel. It’s not intended for data input, but rather data preparation and visualization. That said, a lot of features you might be used to from Excel like highlighting cells or highlighting rows of values are possible! (More here: • Conditional Formatting... )
For this week’s video, I focus on how you can use either a calculation or some inventive custom color applications to get a desired column of data to pop out to the user in a text table. This is particularly handy when you want to narrow your user’s focus on a specific section of the worksheet while keeping the rest of the information there for reference.
You can access the sample workbook built during the video on Tableau Public here: public.tableau...
More about custom color palettes here: onenumber.biz/...

Пікірлер: 41
@onenumbertableau
@onenumbertableau Жыл бұрын
Need help building something like this? 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
@abhinavsingh2894
@abhinavsingh2894 2 жыл бұрын
Bro you're the GOAT. Thanks for this.
@onenumbertableau
@onenumbertableau 2 жыл бұрын
Wow, that's a first. What a compliment! Thank you.
@teri73r1
@teri73r1 13 күн бұрын
terrific video!
@onenumbertableau
@onenumbertableau 13 күн бұрын
Thank you! Glad to hear it helped
@ramprasanth3343
@ramprasanth3343 4 ай бұрын
Thanks a lot for helping to solve the problem. Ive been stuck for an hour with it and this came clutch few hours before my deadline
@onenumbertableau
@onenumbertableau 4 ай бұрын
Glad to hear this helped, you are welcome!
@japanesefunnyshorts8584
@japanesefunnyshorts8584 5 ай бұрын
Thank you this was very helpful. 😊
@onenumbertableau
@onenumbertableau 5 ай бұрын
You are welcome!
@MaryTurczynski
@MaryTurczynski 9 ай бұрын
Awesome! Nice 'simple' approach to this task compared to what I have seen.
@onenumbertableau
@onenumbertableau 9 ай бұрын
Thank you, we're glad to hear this helped!
@adriacometmartinez
@adriacometmartinez Жыл бұрын
I could solve a problem in my job with your video. Thank you so much! Keep it up! 🤙
@onenumbertableau
@onenumbertableau Жыл бұрын
That is so good to hear! Thanks so much for letting us know!
@charub4590
@charub4590 Жыл бұрын
Very helpful, thank you!
@onenumbertableau
@onenumbertableau Жыл бұрын
You are welcome!
@overhearification
@overhearification 2 жыл бұрын
Very helpful. Thanks!
@onenumbertableau
@onenumbertableau 2 жыл бұрын
Absolutely! I'm glad this helped you!
@onenumbertableau
@onenumbertableau Жыл бұрын
Ready to take your Tableau skills to the next level? Check out our upcoming classes here! www.eventbrite.com/o/onenumber-15678294163
@dkliuiko
@dkliuiko Жыл бұрын
Thanks for “use separate legend” bottom!!! I was searching for this option 😊
@onenumbertableau
@onenumbertableau Жыл бұрын
Amazing! We're glad this video helped!
@kanonsaga2004
@kanonsaga2004 Жыл бұрын
This video help me with an issue in my job, thank you so much for your help!!!! keep going!!!!
@onenumbertableau
@onenumbertableau Жыл бұрын
So glad to hear it helped, thanks Gustavo!
@kanonsaga2004
@kanonsaga2004 Жыл бұрын
@@onenumbertableau Hey man!! Do you know how to do a conditional highlight per row for several metrics per month (column)?
@onenumbertableau
@onenumbertableau Жыл бұрын
Hey Gustavo, do you mean something like this? kzfaq.info/get/bejne/rKelfcaD39yYf6s.html&ab_channel=OneNumber-TableauExperts
@DataFam
@DataFam 2 жыл бұрын
Thx Eric, and congrats for the new logo 😀
@onenumbertableau
@onenumbertableau 2 жыл бұрын
Thanks so much!
@oguzhanorhan3198
@oguzhanorhan3198 Жыл бұрын
Thanks for detailed explanation which solved my problem, it's ridiculous that we have to go through this complicated steps just to highlight a column. I had to highlight 32 columns manually which took me 20 mins
@onenumbertableau
@onenumbertableau Жыл бұрын
First, I'm glad to hear this helped solve the problem! Second, I'm sorry it took so long! I'm guessing you went with the second method? If so, I recommend trying Measure Names on color and see if that gets you what you need faster!
@oguzhanorhan3198
@oguzhanorhan3198 Жыл бұрын
​@@onenumbertableau It was just because I was too lazy to watch the other video and create myself a custom color palette :)
@shoppersdream
@shoppersdream 7 ай бұрын
Very Nice, thanks!
@onenumbertableau
@onenumbertableau 7 ай бұрын
You are welcome!
@sudeshnasen6714
@sudeshnasen6714 10 ай бұрын
Thanks for sharing this video. I am facing a similar scenario but what I need is to color different measures based on a condition. When I am dragging measure values to colors like the way you did I am unable to drive it via any condition. Could you please help me here
@onenumbertableau
@onenumbertableau 10 ай бұрын
Hi! I would try to have each column be it's own standalone custom section. Then you can conditionally format them. Here's a video utilizing that technique: onenumber.biz/blog-1/2021/6/11/how-to-highlight-an-entire-row-in-tableau
@explorer_baba2750
@explorer_baba2750 8 ай бұрын
Awesome
@onenumbertableau
@onenumbertableau 8 ай бұрын
Glad to hear you found it helpful!!
@kunalborge5474
@kunalborge5474 2 жыл бұрын
similarly can we highlight texts of the column in tableau
@onenumbertableau
@onenumbertableau 2 жыл бұрын
For sure! Just skip the steps around 1:00 - 2:00 where I do the bars in the background of the worksheet and leave the Marks type dropdown set as Text / Abc and otherwise do all the steps the same. Good luck!
@RajKamalAnkit
@RajKamalAnkit Жыл бұрын
We have a table with four column Sub- category, Profit, Quantity, sale. how can we format the sales tables in tableau based on given condition sale < 5000 then REd 5000 and 15000 then yellow 15000 and 30000 the gray above 30000 then green.
@onenumbertableau
@onenumbertableau Жыл бұрын
Your best bet is to use the individual column trick (demonstrated here: kzfaq.info/get/bejne/rKelfcaD39yYf6s.html) to uniquely label and add conditional formatting to each column
@Oceanooo000
@Oceanooo000 4 ай бұрын
As in the way, I got rows in different color instead of columns🤣. Why?
@onenumbertableau
@onenumbertableau 4 ай бұрын
My only guess is to double-check which fields you used on Rows/Columns and which you used on color. Maybe they are switched around?
How to Repeat Row Labels in Tableau
3:17
OneNumber - Tableau Experts
Рет қаралды 12 М.
Happy birthday to you by Tsuriki Show
00:12
Tsuriki Show
Рет қаралды 11 МЛН
艾莎撒娇得到王子的原谅#艾莎
00:24
在逃的公主
Рет қаралды 53 МЛН
Parenting hacks and gadgets against mosquitoes 🦟👶
00:21
Let's GLOW!
Рет қаралды 13 МЛН
How to highlight an entire row in tableau
15:47
Data Viz Canvas
Рет қаралды 10 М.
Set Actions in Tableau (Proportional Brushing, Asymmetric Drilldown, Color Scaling)
18:00
OneNumber - Tableau Experts
Рет қаралды 1,6 М.
Top 10 Tableau Formatting Tricks
12:20
OneNumber - Tableau Experts
Рет қаралды 4,6 М.
How to highlight a table in #tableau with icons and shapes
9:40
How to Conditionally Format Text Cell Color in Tableau
7:05
Anthony Smoak
Рет қаралды 285 М.
#Tableau - Add Hundreds of Color Palettes
11:31
Andy Kriebel
Рет қаралды 11 М.
Conditionally Format each Column in Tableau Crosstab Table
5:09
Highlight a complete row (in a Tableau Table)
13:12
Down to Earth Data Tips
Рет қаралды 4,3 М.
Tableau - Highlighting
8:06
TutorialsPoint
Рет қаралды 53 М.