Hi everybody!
I got this dashboard:
I want to do click in 'Logistic' word and show only the chart 'Q x logistic' and unhide the chart 'Q x site'.
The same when I do click on 'Site' word. I want to see the chart 'Q x site' and unhide the chart 'Q x logistic'.
How can I do that?
Can you help me? I attach the file.
Hi Agustin,
Right click both sheets on the dashboard and select 'Use as Filter' option
Then Dashboard-> Actions -> Select Action Edit dailog-> Choose Exclude Values
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?
Nov 12, 2018 7:35 AM
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
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?
Nov 12, 2018 10:06 AM
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!)
Simon! Shall you provider me an example with two or more chart with severly data sources?
Thank you!
Nov 13, 2018 1:25 AM
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)