Show/Hide Columns in Tableau with a Parameter!
ฝัง
- เผยแพร่เมื่อ 25 ส.ค. 2024
- 🔔 Book a FREE 15-min Tableau call here: forms.gle/DfW6...
Have you ever been asked to include a table of data that’s way too detailed for the dashboard you’re working on? Sometimes we really just want to see all the numbers. But we might not necessarily want to display all that information at once.
That’s where a Show/Hide option could be effective. Using a parameter, we can enable our end-users to select whether they want to see all the data in the underlying table, or just some summary data (like some total columns).
All you need for this to work is: a) a Boolean parameter, and b) a simple calculated field.
I’ll walk you through exactly how to do this in this week’s video!
Resources:
•Example Workbook: public.tableau...
Connect with us:
•Upcoming Tableau Classes: onenumber.biz/...
•Book an hour to work with Ollie: www.eventbrite...
•Subscribe to the OneNumber Newsletter: onenumber.biz/...
•Follow Ollie Linley on LinkedIn: / oliverlinley
Need help sorting out your Tableau questions? Schedule an hour with Ollie! www.eventbrite.com/e/tableau-office-hours-with-ollie-linley-eastern-time-tickets-439769641837 | Ready to master Tableau? Check out our lineup of upcoming classes! www.eventbrite.com/o/onenumber-15678294163
THANK YOU!!! This is a very simple solution to get the noise out of a table.
I implemented this immediately in one of my wiiide dashboard tables! Don’t forget to hide the column header so you don’t see “True” in the column headers. Thanks for the useful and well-explained tip!
Amazing! Thank you for the feedback Wendy!
Awesome bro
Thank you!
Hey, thanks for this video. This was very helpful. I tried to implement this and False was only showing up under the columns that i wanted to hide but, when i select the column and click on hide then, entire table is hidden. How do i make sure that just the columns that have false are hidden and not the entire table?
Thanks in advance!
Hey! I would do something like:
1. Create a parameter called "Show/Hide Dimension" (Boolean output)
2. Create a calculated field called "Show [Dimension]." This should read: IF [Show/Hide Parameter] THEN [Dimension] ELSE "" END
3. Put this on Rows/Columns
That should help!
Thanks for detailed information! I have a question will this work for single dimension, What if i want to show/hide Sales or only Profit
You're welcome! Unfortunately this method works best for a dimension. You could consider showing "Measure Names" as a filter for your user but they will be able to select/deselect every single measure in the data source.
Hi, that looks good, but you hide all columns and show only Total. Is it Possible for example hide only specific columns? I have 4 measure values by every day and user want to show only specific columns and would be nice to select columns. So is it possible to split this True/False for columns? Thanks a lot
This technique is limited by the totals you have in the view. So trying to show some columns while hiding others of the same dimension level isn't possible because they share the same total in the view. And because Measure Names acts like a dimension, it means that trying to hide one measure while showing others isn't possible with this method!
that's great if you have totals in a basic chart. but I'd like to hide a "column" (all my dimensions are on rows) with a parameter
Can you explain what is on Columns in your worksheet? What kind of column are you trying to hide? Is Measure Names on the Columns shelf and you'd like to be able to control which measures are showing?
The columns are hidden and not showing up again
Hi! If you have hidden data you need to show up again, check out this video to learn how to unhide hidden values: th-cam.com/video/FpRjN-V6tXk/w-d-xo.html&ab_channel=OneNumber-TableauExperts
nice, but I want to show and hid the sub-category column
I don't want the user to have to click that stupid + button -- I want a menu option "show / hide sub category"
Hey - you can do this with a parameter. Create a parameter that allows you to select between two options like show/hide sub-category. Then create a calculated field that says:
CASE par
WHEN 1 THEN Sub-Category
WHEN 2 THEN ' '
END
Replace the sub-cat field on the Rows shelf and show the parameter.
Done!
@@onenumbertableau can you make a video to demonstrate how to do this? I had a similar question. I got a stacked bar chart with two bars, and each has 5 different levels, which add up to be 100%. I want to allow users to choose between showing 2 levels and showing 1 level only. Can you suggest an approach ?