CODEWITHSUNDEEP
tableau-api
Kapil Lehar
Kapil Lehar

Reputation: 81

Sales vs Profit Dashboards in Tableau

I'm trying to achieve a viz in Tableau in which If I click on a paramteer value called sales then sales viz should be selected and if I click on parameter value Profit, then profit viz should be displayed.

Can this be done using parameters in the first place? Or Action filter is the only option?If action filter is the option can I make sure that If I select one parameter say Sales then the other Viz should be hidden automatically.

Upvotes: 1

Views: 971

Answers (3)

Juanma
Juanma

Reputation: 195

I found this link in the tableau training tutorial which might be useful for you.

https://www.tableau.com/learn/tutorials/on-demand/advanced-training-parameters

Steps to follow.

1- Create a parameter with data type "string" which will display either Profit or Sales as values.

2- Create a calculated field with case when function to link your parameter to the measures you want to use (in your case sales or profit).

CASE [Parameter - Sales or Profit] WHEN 'Sales' THEN [Sales] ## assuming your sales dimension is sales. WHEN 'Profit' THEN [Profit] ## assuming your profit dimension is profit. ELSE 'Others' END

This link would be helpful http://onlinehelp.tableau.com/current/pro/desktop/en-us/help.htm#changing-views-using-parameters.html

3- Build your graph

4- Show Parameter control (the one you created in the first step).

Every time you update the parameter, the graph will be updated.

Hope you find this useful.

Upvotes: 2

Alex Blakemore
Alex Blakemore

Reputation: 11896

A simple solution is to put measure values on either the row or column shelf; and measure names on the filter shelf. The show the filter control for measure names.

The downside is that people can choose other measures that you did not intend to expose

Upvotes: 1

Bernardo
Bernardo

Reputation: 3318

Yes, you can do it with parameters. You use a layout container to hold each sheet and then the parameter will filter one and not the other.

See this post for details. http://www.bfongdata.com/2014/10/chart-creation-with-parameters.html

Upvotes: 0

Related Questions