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 in Tableau by priya
14 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 by Cherukuri
• 25,820 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 in Tableau by Cherukuri
• 25,820 points
29 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 19, 2018 in Tableau by Naruto
• 710 points
39 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 in Tableau by Cherukuri
• 25,820 points
57 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
1,801 views
+1 vote
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
77 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 in Tableau by Cherukuri
• 25,820 points
20 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 in Tableau by Cherukuri
• 25,820 points
709 views