Show breakdown from click on one chart

0 votes
Hi, I have data for year wise and region based details. Now i want to show breakdown for a year across different regions and show its sales, profit, etc. How to do this?
Apr 25, 2019 in Tableau by priya
523 views

1 answer to this question.

0 votes

Hi Priya,

You can show the breakdown of one chart in another chart by using the dashboard.

Follow the below steps:

1. Create the main chart that you want to use to show the breakdown in sheet1.

2. Add the details and fields for the breakdown chart in sheet2 (sales, profit, etc).

3. Add both sheets in the dashboard.

4. Now give a filter action from sheet1 and target sheet as sheet2. 

5. Select the Selected field and select the field (Region) that you want to use as a filter and click ok.

6. Now Any click on sheet1 would show you breakdown in sheet2. 

Hope this helps you.

answered Apr 30, 2019 by Cherukuri
• 33,030 points

Related Questions In Tableau

0 votes
1 answer

Show data from 2 different sheets in one sheet.

Hi Anitha, Follow the below steps: 1. Create both ...READ MORE

answered Apr 25, 2019 in Tableau by Cherukuri
• 33,030 points
641 views
0 votes
1 answer
0 votes
1 answer

Replacing Data Source from one Server to Another

I did something similar to it For ...READ MORE

answered Sep 20, 2018 in Tableau by Naruto
• 710 points
1,124 views
0 votes
1 answer

Create global filter from single/multiple data source to multiple data sources on dashboard.

Hi Sindhu, You can use filters from worksheets in ...READ MORE

answered Mar 11, 2019 in Tableau by Cherukuri
• 33,030 points
2,133 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
9,837 views
+2 votes
1 answer
0 votes
1 answer

Calculated filed with if-then

Below is the required code:  IF (NOT ISNULL([test2])) ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
1,563 views
+2 votes
1 answer
0 votes
1 answer

Go from one sheet to another on any selection on chart.

Hi Nithin, Follow these steps to make the ...READ MORE

answered Mar 29, 2019 in Tableau by Cherukuri
• 33,030 points
1,205 views
0 votes
1 answer

How to show percentages on the slices in pie chart in Tableau?

Hi sindhu, You can manually move the labels ...READ MORE

answered Mar 13, 2019 in Tableau by Cherukuri
• 33,030 points
11,631 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP