Dynamic Sorting in Tableau: Here's How to Do It

In this video, I'm demonstrating how to do dynamic sorting in Tableau by any dimension or measure to quickly and easily find the data you're looking for. Tableau is a powerful tool that can be used to analyze data in many different ways. In this video, I'll show you how to use dynamic sorting to quickly and easily find the data you're looking for. This is a great skill to have if you're working with complex data, and it will make your analysis work much faster!
Watch this video to learn how to create dynamic sorting in tableau, and then get to work analyzing your data!
--------------------------------------------
📚 Recommended Books
--------------------------------------------
📚 DATA VISUALISATION & STORYTELLING
Storytelling with Data: A Data Visualisation Guide for Business Professionals amzn.to/3q9ygPw
Data Visualisation: A Handbook for Data Driven Design amzn.to/3qfb1na
The Big Book of Dashboards amzn.to/3q4i3eG
Data Visualization: A Practical Introduction amzn.to/44KYrel
Storytelling with Data : Lets Practice amzn.to/44O7WcL
Tableau Desktop Specialist Certification: amzn.to/44Ocy2P
Tableau Desktop Certified Associate: amzn.to/3Kk2YfV
📚 SQL
SQL for Data Analytics: amzn.to/3rROkGj
SQL 3 books in 1 : amzn.to/3KklUuY
Learning SQL: Generate, Manipulate and Retrieve Data : amzn.to/3Kn34mN
SQL Quick Start Guide: amzn.to/3KInOpx
📚 DATA ENGINEERING
Data Engineering with Python : amzn.to/3YelH1Y
Data Engineering with AWS: amzn.to/3YgXoAL
Fundamentals of Data Engineering: amzn.to/3OAUVxy
Software Architecture: amzn.to/3KmNffX
System Design Interview: amzn.to/3Yhfy5q
Ace Data Science Interview: amzn.to/3rOxcBl
System Design Interview: amzn.to/3OAw8d7
Designing Machine Learning Systems: amzn.to/3YbGxiB
📚 SOFTWARE ENGINEERING
Clean Code amzn.to/47aBnr4
Clean Architecture amzn.to/3OA8VaP
The Programmatic Programmer: amzn.to/4793k2C
-----------------------------------------
👇 CHECK THIS OUT! 👇
-----------------------------------------
🏪 AMAZON STOREFRONT
www.amazon.com/shop/datavizca...
All my recommendations for books, gadgets and gear are also available at my
Amazon storefront. Check it out!
👕 LIKE THE "DATA RELATED GIFTS" WITH CREATIVE, FUNNY & HUMOROUS QUOTES FOR ANYONE WHO LIKE TO LAUGH ?
You can purchase one here: www.datavizcanvas.com/shop/#!/
--------------------------------------------------------------------------------
😍 📧 REACH OUT TO ME ON SOCIAL MEDIA 😍
--------------------------------------------------------------------------------
Instagram: / datavizcanvas
Twitter: / datavizcanvas
Facebook profile.php?...
Linkedin: / gurpreetsingh515
Tableau public public.tableau.com/app/profil...
Website : www.datavizcanvas.com/
-------------------
GEAR I USE
-------------------
📷 Video
Canon EOS RP amzn.to/3QkOpfU
Canon RF 35mm amzn.to/3rNIh5E
Canon RF 14-35mm amzn.to/44JQw0Y
🎙️ Audio
Rode NT-USB Versatile Studio amzn.to/3DCbxyY
Rode PSA1 Professional Studio Arm amzn.to/3ObseWN
Thanks for being a part of this channel and all your support! 💪 🙏
⏱ TIMESTAMPS
00:00​ - Introduction
00:48 - Dynamic Sorting intro
02:12 - What is nested sort
04:32 - Create a new worksheet and calculated fields
‼️ DISCLAIMERS
Links included in this description may be affiliate links. When you buy a product or service with these links, I may receive a small commission. However, there is no additional cost to you :) I genuinely appreciate you supporting my channel so I can continue to provide you with awesome content for free!

[@dollisonjoseph]

Hi I am new to tableau and I find this video helpful to what I need but I have a question?
How do I hide the 2 dynamic sorting fields that are put on the rows shelf?
Thank you in advance!

[@romanvasiura6705]

Thank you for this great lesson 😃

[@DataVizCanvas]

Glad you liked it!

[@px9418]

hi, if i want to do dynamic sorting by measure like the way with parameter, but only within each category of a dimension, is it possible?

[@abhijeetdoshi332]

Great content!!

[@DataVizCanvas]

Thanks Abhijeet 🙏

[@likeminas]

Hi there, thank you for sharing this video. Quick question. Can this be also used for sorting a date type column?

[@BhuvanaNatarajan-fz7on]

Hi, can you show how you can sort and also have custom colors based on each of the columns

[@DataVizCanvas]

Hi, please check the below tutorial on tableau tips and tricks where i have shared how to add different colour for each column that can be measure value or dimension. Please check that out and feel free to reach out if you have any questions. Cheers!

[@siddiquisherry7483]

How to do dynamic sorting when we have all dimensions in the data including date of birth, alphanumeric ice codes.? Thanks

[@ajayb850]

Great content but if we use table calculation we can not able to make total how we can achieve that.

[@DataVizCanvas]

Hi Ajay,
You can add the totals / subtotals by going to Analytics tab and double click on totals or by going to analysis menu and then going to total section. Also you have to make sure that you are following the correct order of operations while using filters . Check out below link for details
help.tableau.com/current/pro/desktop/en-us/order_of_operations.htm

[@nataliacalderon8906]

So disappointing why trivial things like sorting, have their non-intuitive trick. why is the sort button on each column for then??!

[@DataVizCanvas]

Thanks for your feedback. There is defaut sorting option available as well. This is a different way to do dynamic sorting in tableau.