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
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!
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.
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!
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!
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?
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 ?
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
![ละลาย (LALALYE) - DAOU PITTAYA ต้าห์อู๋ พิทยา [OFFICIAL MV]](http://i.ytimg.com/vi/wo6r9TgausI/mqdefault.jpg)
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
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!
THANK YOU!!! This is a very simple solution to get the noise out of a table.
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.
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!
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?
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 ?
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