Conditional Format Tables in Tableau (Like Excel!) - Tableau Tutorial P.5

Tableau Fundamentals (DataCamp) 👉🏼 lukeb.co/TableauDataCamp
(My recommended course that I took to learn Tableau!)
Part 5 of this tutorial covers a common question with visuals: How to conditional format tables, like you used to do all the time in Excel?
00:00 Intro
00:53 Conditional Formatting in Tableau
03:52 Conditional Formatting Alternate Way
04:26 Conclusion
My Tableau tutorial playlist 👉🏼 • Tableau Dashboard Tuto...
Link for Google Sheets - Tableau Superstore Data Set 👉🏼
docs.google.com/spreadsheets/...
Link for Tableau Superstore Dashboard 👉🏼
public.tableau.com/profile/lu...
Recommended Certificates/Courses (Affiliate Links)
==================================
DataCamp:
Python 👉🏼 lukeb.co/PythonBasicsDataCamp
Power BI 👉🏼 lukeb.co/PowerBIDataCamp
Tableau 👉🏼 lukeb.co/TableauDataCamp
R 👉🏼 lukeb.co/RDataCamp
Data Analyst w/ Python 👉🏼 lukeb.co/PythonAnalystDataCamp
DataCamp Subscription (Monthly $25USD) 👉🏼 lukeb.co/DataCampSub
Coursera:
Google Data Analytics Certificate (BEGINNERS START HERE) 👉🏼 lukeb.co/GoogleCert
Python for Everybody 👉🏼 lukeb.co/PythonForEverybody
SQL 👉🏼 lukeb.co/PostgresSQLUofM
Coursera Plus Subscription (Monthly $59USD) 👉🏼 lukeb.co/CourseraMonthly
Coursera Plus Subscription (Annual $399USD) 👉🏼 lukeb.co/CourseraYearly
My Tech for Data Science
(Includes Amazon Affiliate Links)
==================================
💻 Dell New XPS 13 (PC of choice) 👉🏼 geni.us/DellNewXPS13
💻 Dell New XPS 15 👉🏼 geni.us/DellNewXPS15
👨🏼‍💻 M1 Macbook Air 8GB (Mac of choice) 👉🏼 geni.us/M1macAir8GB
👨🏼‍💻 M1 Macbook Pro 8GB 👉🏼 geni.us/M1macPro8GB
🔌 Must-have Mac dock 👉🏼 geni.us/CalDigitTS3
🖥 M1 Multiple monitor adapter 👉🏼 geni.us/DisplayLinkAdapter
⌨️ Mac Keyboard 👉🏼 geni.us/MacMagicKeyboard
🖱 Mac Mouse 👉🏼 geni.us/MacMagicMouse
💾 Small (1TB) External HD 👉🏼 geni.us/WDelements1TB
💾 Large (14TB) External HD 👉🏼 geni.us/WDelements14TB
🏢 Standing Desk 👉🏼 geni.us/StandingDeskFezibo
📗 Data Science Must Read 👉🏼 geni.us/StorytellingWithData
📸 Camera of Choice 👉🏼 geni.us/SonyA6600body
For computers, I recommend checking the manufacturer's website (i.e., dell.com) for deals/rebates
Social Media / Contact Me
======================
🙋🏼‍♂️Website: www.lukebarousse.com/
🌄 Instagram: / lukebarousse
⏰ TikTok: / lukebarousse
📘 Facebook: / datavizbyluke
📥 Business Inquiries: [e-mail]
As an Amazon Associate, I earn a small commission from qualifying purchases on the Amazon links above. It costs you nothing but helps me in keeping the content coming.
tableau #tableaututorial #tableaudashboard

[@Ivy_1057]

Thank you! Very helpful video 👏👍

[@juckchao6307]

Great Tutorial I'v seen so far ! Keep going!

[@LukeBarousse]

Thank you! You're my first comment ever on my videos! congrats! ha

[@eszterarnold2179]

Hey Luke, thank you for your Tableau videos (as well). I am trying to figure out what to do when I have fields with zeros, then the bar chart method doesn't work.

[@LukeBarousse]

I'm not to sure on this one. I'd recommend searching here as I'm sure someone else has encountered this issue as well: community.tableau.com/s/

[@apuroop.mahadev]

Can you post a video about how to conditionally format individual columns in tableau..? Thanks in advance.

[@LukeBarousse]

Let me see what I can do! 🙌🏼

[@shirskakun]

How can I set ranges for the coloring? I have a percentage column (Month over Month calculation) and I want to count all rows with %>5 and %

[@anmolbasnet123]

did you find the solution to this?

[@juckchao6307]

What's the difference between "CNT" and "CNTD" ?

[@LukeBarousse]

That's a great question, here is the difference:
CNT = Count - is an aggregation method that counts ALL the occurrences for a chosen variable (no matter whether it repeats or not). So in the video if we would have done Count on 'Name' we would have had a few thousand values for each of the names, because the names appear a few thousand times in the data source. (Every cell would have had different varying size bar charts in this case. This was not what we wanted in our case, we needed a consistent value across all rows and columns (i.e., 1) to get the bar chart to be the same size in every cell)
CNTD = Count (Distinct) - is an aggregation method that counts a single occurrence of a variable (it does not count repeats). So we use CNTD in the video to count the 'Name', because we know (with how we have made the table) that the 'Name' only will appears once in each row.
Hope this helps!

[@im4485]

Wow tableau really sucks for this