-
1. Re: How can I hide or unhide charts?
Akram Ebrahim Nov 12, 2018 7:08 AM (in response to Agustin Leira) -
2. Re: How can I hide or unhide charts?
Agustin Leira Nov 12, 2018 7:21 AM (in response to Akram Ebrahim)Hi Akram, how are you? Thanks for answer me.
I can't get the goal that I want. Don't works.
Can you do this in the file attach and send me?
-
3. Re: How can I hide or unhide charts?
Simon RuncNov 12, 2018 7:35 AM (in response to Agustin Leira)
hi Agustin,
Here you go. It's basically the same trick I detailed here
Sheet Swap with Action Filters...the simple version!
which uses dummy variables (1One and 0Zero) to show and hide sheets (I've also added a blue pill to each of your sheets, so that they full collapse)
Hope that makes sense, and does the trick
-
hide and unhide sheets_sr.twbx 20.8 KB
-
-
4. Re: How can I hide or unhide charts?
Agustin Leira Nov 12, 2018 10:00 AM (in response to Simon Runc)Hi Simon, was very useful.
I attach a file but now I have three options: site, logistic and month.
It's possible do with more than two charts?
-
hide and unhide sheets_sr.twbx 28.7 KB
-
-
5. Re: How can I hide or unhide charts?
Simon RuncNov 12, 2018 10:06 AM (in response to Agustin Leira)
Yes we can do as many as you like! We just need to set up the actions so when we click "Logistic", say, it kills both Site and Mes ...and so on.
You are also unable to trigger actions from the title, so in the attached I actually removed the title and added the text to the sheet (so it looked like a title!)
-
hide and unhide sheets_srv2.twbx 25.0 KB
-
-
6. Re: How can I hide or unhide charts?
Agustin Leira Nov 12, 2018 11:02 AM (in response to Simon Runc)Thank you so much Simon, you are a genius !!!
-
7. Re: How can I hide or unhide charts?
Agustin Leira Nov 12, 2018 12:55 PM (in response to Simon Runc)Simon! Shall you provider me an example with two or more chart with severly data sources?
Thank you!
-
8. Re: How can I hide or unhide charts?
Simon RuncNov 13, 2018 1:25 AM (in response to Agustin Leira)
hi Agustin,
I assume you mean with several datasources?
It's basically exactly the same, you just need to set up the 1One and 0Zero in both datasources, and then with actions you are able to pass filter dimensions across data-sources
Here's an document I put together ages ago, showing action driven sheet swapping across 2 datasources.
Sheet Swapping using Dashboard Actions (...or the Illusion of a Full Outer Join on Blended Data)