Hello! First off, I'm a big fan of Tableau and the hours its saved me coding. Currently I am having an issue that I have yet to find a solution for on the forums.
I have been building out dashboards recently using two data sources. The first and largest data source is from our database, the second from a small CSV. The CSV file has data unrelated to that coming from the DB so the sheets themselves are all fairly simple. The dashboards all have to do with student statistics, and I have created action filters so people can filter by "major" or "college". This all works flawlessly however the few sheets that rely on the CSV data remain unaffected by these filters for obvious reasons.
My question is: Is there a way to hide the sheets coming from the CSV file when any filter is selected? We would rather simply not show them than confuse people with the CSV sheets data remaining unchanged when a filter is applied. After searching for quite awhile I came across a post here that sort of does this the opposite way (Sheet is hidden UNTIL you click on a filter) and I have been trying to reverse engineer it to no avail. I have attached one of my sheets that shows this situation in action, as well as the sheet I found on the forums that shows/hides when a filter is selected.
On the sheet attached below named "Enrollment Sheet-TEST" the sheet "Students From Under-Represented Groups" comes from a separate data source and is not affected by the filters on the dashboard. As you can see "Pell Eligible" and their statistics are simply floating text objects that I would need to hide on a filter select as well. What was asked of me what to simply make the "Students From Under-Represented Groups" sheet and the "Pell Eligible" image invisible/disappear when any filter is selected.
Any help would be greatly appreciated, I have been trying to figure out a solution for quite some time now to no avail.
Thanks in advance for your time, Cheers!