How to Apply a Unique Color Range Per Row in Tableau (Quick Tip)

Do you want to apply a unique color legend to each row or column in a Tableau worksheet? With some creative calculations, you can!

By default, Tableau assigns a single color range to an entire worksheet. That makes sense in a lot of circumstances, but not always. Let's say you're comparing sales across categories that are significantly different sizes. The small category will always be on the low end of the spectrum even if there is significant variation from one cell to the next.

By using a calculation with the WINDOW_MAX function, you can ensure a row is always being compared against itself rather than the entire worksheet. Ready to learn how? Check out this video!


Connect with us:
•Book an Office Hour with Eric: https://www.eventbrite.com/e/tableau-...
•Tableau Passport Program: https://onenumber.biz/tableau-trainin...
•Upcoming Tableau Classes: https://www.eventbrite.com/o/onenumbe...
•Subscribe to the OneNumber Newsletter: https://onenumber.biz/newsletter
•Follow Eric on LinkedIn:   / eric-parker-37513249  


Resources:
•Example Tableau Workbook: https://public.tableau.com/app/profil...
•How Table Calculations Work: https://onenumber.biz/blog-1/2023/4/1...
•Tableau WINDOW Functions: https://onenumber.biz/blog-1/2023/11/...
•Unique Color Legend per Measure: https://onenumber.biz/blog-1/2022/2/1...



Chapters:
1:22 Office Hours
5:11 Multiple Measures Version
6:20 Passport