5 Replies Latest reply on Jan 23, 2018 3:54 PM by suvas.chandra

Dynamic Column Visibility

suvas.chandra Jan 23, 2018 1:48 PM

I have two pie charts and one dashboard in my report. First pie chart is colored by Industry (Healthcare, Manufacturing, Financial, Automobile etc.). Second pie chart
is colored by Investment Type (Buyout, Venture Capital, Special Situations etc.). Below this two pie charts I have a report. Along with all other fields
(Dimensions and Measures) I have Industry and Investment Type columns. I want to show only one of them at the same time. If the user select one slice (let's say, Healthcare)
, the report should display Industry column and it should be filtered out by Healthcare. It is the same way for Investment Type..Industry will not be displayed
once Investment Type is selected.

Doable ? I could not find any example. Please feel free to use any data.

1. Re: Dynamic Column Visibility

keerthi baikan Jan 23, 2018 2:13 PM (in response to suvas.chandra)

Hi Suvas,

Check if this example helps you
Using parameters - I created a dynamic dashboard that swaps visuals

Regards
Keerthi
Like Show 0 Likes(0)

Actions
2. Re: Dynamic Column Visibility

Jyothisree Rayagiri Jan 23, 2018 2:18 PM (in response to suvas.chandra)

Hi

You can create a parameter with string values - Industry,Healthcare and use it as a dimension selector on your report.
Create two calculated fields - first set to the dimension selected in the parameter - and the other to select the other one
drop both of them to your report - filter on one dimension based on the pie chart clicked

//Jyothi
Like Show 0 Likes(0)

Actions
3. Re: Dynamic Column Visibility

suvas.chandra Jan 23, 2018 3:50 PM (in response to keerthi baikan)

Thanks for sharing. This is different. I want the column to be displayed with filter based on slice of a pie selection.
Like Show 0 Likes(0)

Actions
4. Re: Dynamic Column Visibility

suvas.chandra Jan 23, 2018 3:53 PM (in response to Jyothisree Rayagiri)

Jyothi,

Sounds interesting. I will try that. Is there any example ?

Suvas
Like Show 0 Likes(0)

Actions
5. Re: Dynamic Column Visibility

suvas.chandra Jan 23, 2018 3:54 PM (in response to Jyothisree Rayagiri)

Jyothi,

I don't want it parameter controlled though....
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

Dynamic Column Visibility

1. Re: Dynamic Column Visibility

2. Re: Dynamic Column Visibility

3. Re: Dynamic Column Visibility

4. Re: Dynamic Column Visibility

5. Re: Dynamic Column Visibility

Sign In or
Create your Account

Actions

More Like This

Sign In or Create your Account

Sign In or
Create your Account