Please provide the solution for this one. Really struggling with this one. I am having 12 pie chart on the dashboards and each of them having a drill down. All of them having the same issue. Please guys if you could help me out with this one.
Thanks and Regards,
Did you look at Manideep's solution?
I have tried the solution which Mandeep suggested. It didn't work.
Please find the attached workbook for the same.
Summarizing my question again, Select any "Sub-Category A" D1 and you will be navigated to D2 and same "Subcategory A" on D2 will get highlighted. This is perfectly fine.
On D2, change the "Subcategory A" to "Subcategory B" by click on it & click on Home.
After Coming on D1, Click on "Sub-Category C", it will take you to the D2, where "Subcategory B" & "Sub-Category C" will be highlighted. (Actually there should be only "Sub-Category C" should be highlighted)
Thanks And Regards,
1 of 1 people found this helpful
This is what's going on in there. You have a highlight action when you go to D2. It works as expected.
When you are on D2 and when you change the sub-category by clicking on a slice, Tableau remembers that the user clicked on Bookcases. If the user does not clear Bookcases on D2 before going back to D1, when you return to D2 Tableau remembers that the user previously clicked Bookcases and leaves that highlighted when you return. To demonstrate, click HOME to go back to D1. Then, instead of clicking a subcategory on D1, click the D2 tab. When you go to D2 that way, Bookcases is still highlighted. Tableau keeps that context. A highlight action doesn't change that, and that's why you get two pie slices highlighted on the second trip back to D2. (Again, this only happens if the user changed the sub-category while on D2.
Essentially you have conflicting actions.
I know this is just a sample, but is there a particular reason why you need the second dashboard? Given the example, you can do the same thing without D2. See attached. Now if you select a sub-category, the CT sheet pops out. If you select another one, CT changes. If you click the same slice (clearing the selection), the CT sheet goes away. I did this by putting a bogus sub-category-2 sheet plus the CT sheet in a container that floats behind the sub category sheet. When nothing is selected, the two sheets go empty. When something gets selected, both fill, and the bogus sub-category sheet pushes the CT sheet into view.
If you didn't require the title on the CT sheet, you could even do away with the extra sub-category pop-out sheet. Before going into a lot of explanation, let me know if the behavior on D1 in the attached will serve your purpose.
I have used two dashboard the reason being I have total 12 pie charts on the D1 and for each of which I need to show the drill down in the D2.
Let me know what can be done in this case. Please help me find the way out of this.
PS: I have mentioned the same at the top after the Mandeep's reply.
Thanks and Regards,
You can still use the technique I showed you, even with 12 pie charts.
I can go into all sorts of descriptions of what you can do, but it really depends on what your 12-sheet dashboard looks like, and what you want the user to see. I would only be guessing without an actual workbook that simulates your current main dashboard and the result you want the user to see when he selects something.
The way you are doing it now is going to cause you conflicts between actions.
Hack up your workbook with only 2 or 3 pie charts and anonymize your data. Follow the steps in this video: Anonymize your Tableau Package Data for Sharing
I can play with your workbook and show you some thing you can do to keep it all in one dashboard and eliminate the action conflicts.