Dear Tableau community,
Is it possible to change parameter list value based on selected value in other parameter
Example I have this data:
Group DistiName
1 Disti A
1 Disti B
1 Disti C
2 Disti F
2 Disti G
I have 2 parameter : Group and Distiname
The requirement is when I select Parameter Group = 1, then the list of Distiname in Parameter Distiname should only show Disti A, Disti B, Disti C. When I select Parameter Group =2, the list of Distiname in Parameter Distiname should only show Disti F and Disti G.
Attached is the sample workbook
Note: Please DO NOT suggest to use FILTER because in the real requirement, I need to display the ranking of the selected disti based some on some revenue value compare against all Disti. Ex : Rank 2 out of 9 Disti. That's why I am not able to use Filter here.
Thank You Very much
Regards,
Ratna
@Ratna Sari
You can use the data driven dashboard extension:
https://extensiongallery.tableau.com/extensions/101
To use this dashboard extension, I created a filter list parameter in your sheet list and select true:
[Group]=[Param1]
Then I created a new parameter [Param DistiName]
I showed the parameter control, created a new dashboard and drag and drop this sheet.
Then I add the extension (you can added from the extension gallery or from the link and download the trex file), and configure it:
In the configure section I selected your "List" sheet, then the [Param DistiName] and last the DistiName Field, after that, I clic on Options:
In this tab, the most important is to check the option to update list when a parameter changes, in this case your first parameter Param1 and then clic on ok.
Attached you will find the workbook with some extra content.
If this post resolves the question "Select as Best" or if it assists in resolving the question, please "Upvote". This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.
Regards,
Diego
